APPS.PO_INTERFACE_S dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 3031: FROM financials_system_params_all --

3027: x_retvar := FND_INSTALLATION.get_app_info(x_product,x_opm_installed,x_dummy,x_dummy);
3028: BEGIN
3029: l_progress := '060';
3030: SELECT inventory_organization_id INTO x_inv_org_id
3031: FROM financials_system_params_all --
3032: WHERE NVL(org_id, -99) = NVL(g_purchasing_ou_id, -99); --
3033:
3034: l_progress := '070';
3035: SELECT process_enabled_flag INTO x_process_org

Line 6574: FROM financials_system_params_all --

6570:
6571: l_progress := '040';
6572: SELECT set_of_books_id
6573: INTO x_sob_id
6574: FROM financials_system_params_all --
6575: WHERE NVL(org_id, -99) = NVL(g_purchasing_ou_id, -99); --
6576:
6577:
6578: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 7817: FROM financials_system_params_all fsp --

7813: /* Retrieve Invoice Match Option from Financial System Parameters */
7814: /*
7815: SELECT fsp.match_option
7816: INTO x_invoice_match_option
7817: FROM financials_system_params_all fsp --
7818: WHERE NVL(org_id, -99) = NVL(g_purchasing_ou_id, -99); --*/
7819: end if;
7820:
7821: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 8525: -- Bug 3794198: Join to financials_system_params_all and gl_sets_of_books to

8521:
8522: ELSE -- ( p_interface_source_code NOT IN ('SOURCING','CONSUMPTION_ADVICE') )
8523:
8524: -- Retrieve information from the backing Requisition Line.
8525: -- Bug 3794198: Join to financials_system_params_all and gl_sets_of_books to
8526: -- retrieve the value of l_req_ou_currency_code, the functional currency of ROU
8527: SELECT PRL.currency_code
8528: , GSB.currency_code
8529: , PRL.unit_price

Line 8540: financials_system_params_all FSP,

8536: , l_req_currency_unit_price
8537: , l_req_amount
8538: , l_req_currency_amount
8539: FROM po_requisition_lines_all PRL,
8540: financials_system_params_all FSP,
8541: gl_sets_of_books GSB
8542: WHERE PRL.requisition_line_id = p_requisition_line_id
8543: AND nvl(PRL.org_id, -99) = nvl(FSP.org_id, -99)
8544: AND FSP.set_of_books_id = GSB.set_of_books_id;

Line 12306: financials_system_params_all fsp --

12302: mtl_system_items msi,
12303: po_line_types plt,
12304: po_vendors pov,
12305: po_system_parameters_all psp, --
12306: financials_system_params_all fsp --
12307: WHERE pli.item_id = msi.inventory_item_id(+)
12308: AND nvl(msi.organization_id,fsp.inventory_organization_id)=
12309: fsp.inventory_organization_id
12310: AND pli.line_type_id = plt.line_type_id

Line 12368: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --

12364: --bug 1942696 hr_location changes to reflect the new view
12365: MTL_SYSTEM_ITEMS MSI ,
12366: PO_LINE_TYPES PLT ,
12367: PO_SYSTEM_PARAMETERS_ALL PSP , --
12368: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
12369: PO_VENDORS POV,
12370: PO_HEADERS_INTERFACE PHI
12371: WHERE PLI.LINE_NUM = x_po_line_num
12372: AND PLI.shipment_num is not null

Line 12489: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --

12485: PO_REQUISITION_LINES_ALL PRL, --
12486: MTL_SYSTEM_ITEMS MSI ,
12487: PO_LINE_TYPES PLT ,
12488: PO_SYSTEM_PARAMETERS_ALL PSP , --
12489: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
12490: PO_VENDORS POV,
12491: PO_HEADERS_INTERFACE PHI
12492: WHERE PLI.LINE_NUM = x_po_line_num
12493: AND PLI.shipment_num is not null

Line 12617: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --

12613: --bug 1942696 hr_location changes to reflect the new view
12614: MTL_SYSTEM_ITEMS MSI ,
12615: PO_LINE_TYPES PLT ,
12616: PO_SYSTEM_PARAMETERS_ALL PSP , --
12617: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
12618: PO_VENDORS POV,
12619: PO_HEADERS_INTERFACE PHI
12620: WHERE PLI.LINE_NUM = x_po_line_num
12621: AND PLI.shipment_num is not null

Line 13170: FROM financials_system_params_all --

13166:
13167: begin
13168: SELECT inventory_organization_id
13169: INTO x_inv_org_id
13170: FROM financials_system_params_all --
13171: WHERE NVL(org_id, -99) = NVL(p_purchasing_ou_id, -99); --
13172:
13173: select item_id
13174: into x_item_id

Line 13918: from financials_system_params_all req_fsp

13914: END IF;
13915:
13916: select req_fsp.set_of_books_id
13917: into l_req_ou_sob_id
13918: from financials_system_params_all req_fsp
13919: where req_fsp.org_id = p_requesting_ou_id; --
13920:
13921: l_progress := '010';
13922: select po_fsp.set_of_books_id

Line 13924: from financials_system_params_all po_fsp

13920:
13921: l_progress := '010';
13922: select po_fsp.set_of_books_id
13923: into l_po_ou_sob_id
13924: from financials_system_params_all po_fsp
13925: where po_fsp.org_id = p_purchasing_ou_id; --
13926:
13927: IF l_req_ou_sob_id = l_po_ou_sob_id THEN
13928: x_rate := NULL;