APPS.PO_CORE_S dependencies on GL_SETS_OF_BOOKS

Line 229: financials_system_parameters and gl_sets_of_books table

225: retreive organization name and sob id from
226: org_organization_definitions table based on org_id
227: else
228: retreive purchasing organization from
229: financials_system_parameters and gl_sets_of_books table
230:
231: NOTES :
232:
233: =========================================================================== */

Line 271: gl_sets_of_books sob

267: INTO org_id,
268: sob_id,
269: org_name
270: FROM financials_system_parameters fsp,
271: gl_sets_of_books sob
272: WHERE fsp.set_of_books_id = sob.set_of_books_id;
273:
274: end if;
275: x_progress := 40;

Line 347: financials_system_parameters,gl_sets_of_books,

343: x_qty_rcv_tolerance
344:
345:
346: ALGORITHM : Retreive po parameters from
347: financials_system_parameters,gl_sets_of_books,
348: po_system_parameters and rcv_parameters tables.
349:
350: NOTES :
351:

Line 525: financials_system_parameters,gl_sets_of_books,

521: x_acceptance_required_flag
522:
523:
524: ALGORITHM : Retreive po parameters from
525: financials_system_parameters,gl_sets_of_books,
526: po_system_parameters and rcv_parameters tables.
527:
528: NOTES :
529:

Line 681: gl_sets_of_books sob,

677: x_ship_via_lookup_code,
678: x_qty_rcv_tolerance,
679: x_acceptance_required_flag
680: FROM financials_system_parameters fsp,
681: gl_sets_of_books sob,
682: po_system_parameters psp,
683: rcv_parameters rcv,
684: ap_product_setup aps
685: WHERE fsp.set_of_books_id = sob.set_of_books_id

Line 1931: GL_SETS_OF_BOOKS GSB,

1927: INTO x_base_currency,
1928: x_po_currency
1929: FROM PO_HEADERS_ALL POH,
1930: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
1931: GL_SETS_OF_BOOKS GSB,
1932: PO_RELEASES_ALL POR
1933: WHERE POR.po_release_id = x_object_id
1934: AND POH.po_header_id = POR.po_header_id
1935: AND NVL(POR.org_id,-99) = NVL(FSP.org_id,-99) --< Bug 3549096 >

Line 2634: GL_SETS_OF_BOOKS GSB,

2630: INTO l_base_currency,
2631: l_po_currency
2632: FROM PO_HEADERS_ALL POH,
2633: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
2634: GL_SETS_OF_BOOKS GSB,
2635: PO_RELEASES_ALL POR
2636: WHERE POR.po_release_id = p_object_id
2637: AND POH.po_header_id = POR.po_header_id
2638: AND NVL(POR.org_id,-99) = NVL(FSP.org_id,-99) --< Bug 3549096 >

Line 6175: gl_sets_of_books gsob

6171: x_legal_entity_id
6172: FROM hr_organization_information hoi,
6173: hr_all_organization_units haou,
6174: mtl_parameters mp,
6175: gl_sets_of_books gsob
6176: WHERE mp.organization_id = p_inv_org_id
6177: AND mp.organization_id = haou.organization_id
6178: AND haou.organization_id = hoi.organization_id
6179: AND hoi.org_information_context = 'Accounting Information'