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 2063: GL_SETS_OF_BOOKS GSB,

2059: INTO x_base_currency,
2060: x_po_currency
2061: FROM PO_HEADERS_ALL POH,
2062: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
2063: GL_SETS_OF_BOOKS GSB,
2064: PO_RELEASES_ALL POR
2065: WHERE POR.po_release_id = x_object_id
2066: AND POH.po_header_id = POR.po_header_id
2067: AND NVL(POR.org_id,-99) = NVL(FSP.org_id,-99) --< Bug 3549096 >

Line 2766: GL_SETS_OF_BOOKS GSB,

2762: INTO l_base_currency,
2763: l_po_currency
2764: FROM PO_HEADERS_ALL POH,
2765: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
2766: GL_SETS_OF_BOOKS GSB,
2767: PO_RELEASES_ALL POR
2768: WHERE POR.po_release_id = p_object_id
2769: AND POH.po_header_id = POR.po_header_id
2770: AND NVL(POR.org_id,-99) = NVL(FSP.org_id,-99) --< Bug 3549096 >

Line 6383: gl_sets_of_books gsob

6379: x_legal_entity_id
6380: FROM hr_organization_information hoi,
6381: hr_all_organization_units haou,
6382: mtl_parameters mp,
6383: gl_sets_of_books gsob
6384: WHERE mp.organization_id = p_inv_org_id
6385: AND mp.organization_id = haou.organization_id
6386: AND haou.organization_id = hoi.organization_id
6387: AND hoi.org_information_context = 'Accounting Information'