SELECT l.lookup_code, l.meaning
    FROM so_lookups l
   WHERE l.lookup_type = 'FREIGHT_TERMS' AND l.enabled_flag = 'Y'
     AND TRUNC (SYSDATE) BETWEEN NVL (start_date_active, TRUNC (SYSDATE))
                             AND NVL (end_date_active, TRUNC (SYSDATE))
ORDER BY l.meaning

image

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 Somebaby 的頭像
    Somebaby

    Oracle eBS經驗分享

    Somebaby 發表在 痞客邦 留言(0) 人氣()