DBA Data[Home] [Help]

APPS.PO_BUYER_WORKLOAD_SV dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 85: financials_system_parameters FSP,

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

Line 251: financials_system_parameters FSP,

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

Line 499: financials_system_parameters fsp

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