DBA Data[Home] [Help]

APPS.CST_MGD_MSTR_BOOK_RPT dependencies on MFG_LOOKUPS

Line 1007: FROM mfg_lookups MLS

1003: lc_meaning VARCHAR2 (80);
1004: BEGIN
1005: SELECT MLS.meaning
1006: INTO lc_meaning
1007: FROM mfg_lookups MLS
1008: WHERE MLS.lookup_type = 'CST_BREAK_BY_INV'
1009: AND MLS.lookup_code = p_break_by
1010: AND MLS.enabled_flag = 'Y';
1011:

Line 1037: FROM mfg_lookups MLS

1033: lc_meaning VARCHAR2 (80);
1034: BEGIN
1035: SELECT MLS.meaning
1036: INTO lc_meaning
1037: FROM mfg_lookups MLS
1038: WHERE MLS.lookup_type = 'CST_ALL_OR_ONE_INV'
1039: AND MLS.lookup_code = p_all_or_single
1040: AND MLS.enabled_flag = 'Y';
1041:

Line 1865: ,mfg_lookups MLS

1861: BEGIN
1862: SELECT MLS.meaning
1863: INTO lc_transaction_action
1864: FROM mtl_material_transactions MMT
1865: ,mfg_lookups MLS
1866: WHERE MLS.lookup_code = MMT.transaction_action_id
1867: AND MLS.lookup_type = 'MTL_TRANSACTION_ACTION'
1868: AND MMT.transaction_id = p_transaction_id;
1869: