Skip to main content

Posts

Showing posts from September, 2018

SQL for Before / After a character (For Example / OR _ )

SELECT flv1.meaning, flv1.attribute1,NVL(SUBSTR(flv1.meaning, 0, INSTR(flv1.meaning, '/')-1), flv1.meaning) Before, SUBSTR(flv1.meaning, INSTR(flv1.meaning, '/') + 2) AFTER                           FROM   fnd_lookup_values flv1                            WHERE  flv1.lookup_type = 'XWII_BOL_NAME_REPLACEMENT'                            AND    flv1.enabled_flag = 'Y'                           AND    TRUNC (SYSDATE) BETWEEN TRUNC (NVL (flv1.start_date_active,SYSDATE))                                                AND TRUNC (NVL (flv1.end_date_active,SYSDATE)) ...
Post a Comment
Read more

Lookup Query

Lookup Query: SELECT flv1.description           FROM   fnd_lookup_values flv1            WHERE  flv1.lookup_type = 'XWII_WSP_RPT_MTRL_HLD_CUSTOMER'            AND    flv1.enabled_flag = 'Y'           AND    TRUNC (SYSDATE) BETWEEN TRUNC (NVL (flv1.start_date_active,SYSDATE))                                        AND TRUNC (NVL (flv1.end_date_active,SYSDATE))           AND    flv1.LANGUAGE = 'US'
Post a Comment
Read more