DBA Data[Home] [Help]

APPS.PO_BUYER_WORKLOAD_SV dependencies on MTL_SYSTEM_ITEMS

Line 84: mtl_system_items MSI,

80: x_unassigned_urgent,
81: x_unassigned_late,
82: x_unassigned_needed
83: FROM po_requisition_lines_v PORL,
84: mtl_system_items MSI,
85: financials_system_parameters FSP,
86: gl_sets_of_books GSB
87: WHERE PORL.suggested_buyer_id is NULL
88: AND NVL(PORL.LINE_LOCATION_ID, -999) = -999

Line 250: mtl_system_items MSI,

246: x_num_urgent,
247: x_num_late,
248: x_num_needed
249: FROM po_requisition_lines_v PORL,
250: mtl_system_items MSI,
251: financials_system_parameters FSP,
252: gl_sets_of_books GSB
253: WHERE PORL.suggested_buyer_id = x_buyer_id
254: AND NVL(PORL.LINE_LOCATION_ID, -999) = -999

Line 419: mtl_system_items MSI

415: */
416: CURSOR C(x_inventory_organization_id number,x_sob_currency_code number) is
417: SELECT PORL.rowid
418: FROM po_requisition_lines PORL,
419: mtl_system_items MSI
420: WHERE
421: NVL(PORL.LINE_LOCATION_ID, -999) = -999
422: -- PORL.line_location_id IS NULL
423: AND PORL.source_type_code = 'VENDOR'