APPS.INV_3PL_BILLING_UNITS_PVT dependencies on MFG_LOOKUPS

Line 213: || 'FROM mfg_lookups lookup, mtl_billing_sources_b blsrc '

209: || 'AND mcp.client_code = rule_lines.client_code ';
210:
211: d_sql_stmt := d_sql_stmt || 'AND EXISTS ('
212: || 'SELECT 1 '
213: || 'FROM mfg_lookups lookup, mtl_billing_sources_b blsrc '
214: || 'WHERE blsrc.billing_source_code = ''S'' '
215: || 'AND rule_lines.billing_source_id = blsrc.billing_source_id '
216: || 'AND lookup.lookup_type = ''MTL_3PL_SEEDED_SOURCE'' '
217: || 'AND lookup.lookup_code IN (7, 8) '

Line 672: FROM mtl_billing_sources_b blsrc, mfg_lookups lookup

668: IF v_billing_source_id IS NOT NULL THEN
669: BEGIN
670: SELECT meaning
671: INTO l_meaning
672: FROM mtl_billing_sources_b blsrc, mfg_lookups lookup
673: WHERE billing_source_id = v_billing_source_id
674: AND
675: ( ( decode(blsrc.billing_source_code, 'C', lookup.lookup_type, NULL) = 'MTL_3PL_CUSTOM_SOURCE')
676: OR ( decode(blsrc.billing_source_code, 'S', lookup.lookup_type, NULL) = 'MTL_3PL_SEEDED_SOURCE')