APPS.INV_3PL_BILLING_UNITS_PVT dependencies on MTL_BILLING_SOURCES_B

Line 180: lc_billing_source_id mtl_billing_sources_b.billing_source_id%TYPE;

176: lc_net_Reading csi_counter_readings.net_Reading%TYPE;
177: lc_last_reading csi_counter_readings.net_Reading%TYPE;
178: lc_billing_uom mtl_system_items.primary_uom_code%TYPE;
179: lc_service_item_org_id mtl_billing_rule_lines_v.service_item_org_id%TYPE;
180: lc_billing_source_id mtl_billing_sources_b.billing_source_id%TYPE;
181: lc_billing_source_name mtl_billing_sources_tl.name%TYPE;
182: lc_last_computation_Date DATE;
183: lc_service_line_start_date DATE;
184: lc_service_line_end_date DATE;

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')