APPS.PO_CORE_S dependencies on FINANCIALS_SYSTEM_PARAMETERS

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 270: FROM financials_system_parameters fsp,

266: sob.name
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;

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 680: FROM financials_system_parameters fsp,

676: x_manual_rfq_num_type,
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

Line 5657: PO_DEBUG.debug_stmt(l_log_head,l_progress,'using FINANCIALS_SYSTEM_PARAMETERS');

5653: IF (p_org_id IS NULL) THEN
5654:
5655: l_progress := '020';
5656: IF g_debug_stmt THEN
5657: PO_DEBUG.debug_stmt(l_log_head,l_progress,'using FINANCIALS_SYSTEM_PARAMETERS');
5658: END IF;
5659:
5660: SELECT FSP.req_encumbrance_flag, FSP.purch_encumbrance_flag
5661: INTO l_req_enc_flag, l_purch_enc_flag

Line 5662: FROM FINANCIALS_SYSTEM_PARAMETERS FSP

5658: END IF;
5659:
5660: SELECT FSP.req_encumbrance_flag, FSP.purch_encumbrance_flag
5661: INTO l_req_enc_flag, l_purch_enc_flag
5662: FROM FINANCIALS_SYSTEM_PARAMETERS FSP
5663: ;
5664:
5665: l_progress := '030';
5666:

Line 6080: FROM financials_system_parameters fsp,

6076: --SQL What: Check if inv org p_inv_org_id is in current set of books
6077: --SQL Why: Outcome determines output parameter x_in_sob
6078: SELECT 'Y'
6079: INTO l_in_sob
6080: FROM financials_system_parameters fsp,
6081: hr_organization_information hoi,
6082: mtl_parameters mp
6083: WHERE mp.organization_id = p_inv_org_id
6084: AND mp.organization_id = hoi.organization_id