APPS.PO_BUYER_WORKLOAD_SV dependencies on GL_SETS_OF_BOOKS

Line 86: gl_sets_of_books GSB

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
90: AND nvl(PORL.cancel_flag,'N')='N'

Line 252: gl_sets_of_books GSB

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
256: AND nvl(PORL.cancel_flag,'N')='N'

Line 409: /* Bug 2496101. Removed financial_system_parameters and gl_sets_of_books

405: x_rowid ROWID;
406: x_inventory_organization_id NUMBER;
407: x_sob_currency_code NUMBER;
408:
409: /* Bug 2496101. Removed financial_system_parameters and gl_sets_of_books
410: * that used to be in the FROM clause in the select query below.
411: * This was done due to performance problem with the cartesian
412: * joins. We used to get the inventory_organization_id and
413: * currency_code from these table. Now we get them in a separate

Line 498: FROM gl_sets_of_books sob,

494: * with the cartesian join between the tables.
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);