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
89: -- AND PORL.line_location_id IS NULL
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
255: -- AND PORL.line_location_id IS NULL
495: */
496: SELECT fsp.inventory_organization_id,sob.currency_code
497: INTO x_inventory_organization_id, x_sob_currency_code
498: FROM gl_sets_of_books sob,
499: financials_system_parameters fsp
500: WHERE fsp.set_of_books_id = sob.set_of_books_id;
501:
502: OPEN C(x_inventory_organization_id,x_sob_currency_code);
503: LOOP