APPS.PO_INTERFACE_S dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 3375: FROM financials_system_params_all --

3371: x_retvar := FND_INSTALLATION.get_app_info(x_product,x_opm_installed,x_dummy,x_dummy);
3372: BEGIN
3373: l_progress := '060';
3374: SELECT inventory_organization_id INTO x_inv_org_id
3375: FROM financials_system_params_all --
3376: WHERE NVL(org_id, -99) = NVL(g_purchasing_ou_id, -99); --
3377:
3378: l_progress := '070';
3379: SELECT process_enabled_flag INTO x_process_org

Line 7152: FROM financials_system_params_all --

7148:
7149: l_progress := '040';
7150: SELECT set_of_books_id
7151: INTO x_sob_id
7152: FROM financials_system_params_all --
7153: WHERE NVL(org_id, -99) = NVL(g_purchasing_ou_id, -99); --
7154:
7155:
7156: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 8424: FROM financials_system_params_all fsp --

8420: /* Retrieve Invoice Match Option from Financial System Parameters */
8421: /*
8422: SELECT fsp.match_option
8423: INTO x_invoice_match_option
8424: FROM financials_system_params_all fsp --
8425: WHERE NVL(org_id, -99) = NVL(g_purchasing_ou_id, -99); --*/
8426: end if;
8427:
8428: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

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

9133:
9134: ELSE -- ( p_interface_source_code NOT IN ('SOURCING','CONSUMPTION_ADVICE') )
9135:
9136: -- Retrieve information from the backing Requisition Line.
9137: -- Bug 3794198: Join to financials_system_params_all and gl_sets_of_books to
9138: -- retrieve the value of l_req_ou_currency_code, the functional currency of ROU
9139: SELECT PRL.currency_code
9140: , GSB.currency_code
9141: , PRL.unit_price

Line 9152: financials_system_params_all FSP,

9148: , l_req_currency_unit_price
9149: , l_req_amount
9150: , l_req_currency_amount
9151: FROM po_requisition_lines_all PRL,
9152: financials_system_params_all FSP,
9153: gl_sets_of_books GSB
9154: WHERE PRL.requisition_line_id = p_requisition_line_id
9155: AND nvl(PRL.org_id, -99) = nvl(FSP.org_id, -99)
9156: AND FSP.set_of_books_id = GSB.set_of_books_id;

Line 13028: financials_system_params_all fsp --

13024: mtl_system_items msi,
13025: po_line_types plt,
13026: po_vendors pov,
13027: po_system_parameters_all psp, --
13028: financials_system_params_all fsp --
13029: WHERE pli.item_id = msi.inventory_item_id(+)
13030: AND nvl(msi.organization_id,fsp.inventory_organization_id)=
13031: fsp.inventory_organization_id
13032: AND pli.line_type_id = plt.line_type_id

Line 13090: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --

13086: --bug 1942696 hr_location changes to reflect the new view
13087: MTL_SYSTEM_ITEMS MSI ,
13088: PO_LINE_TYPES PLT ,
13089: PO_SYSTEM_PARAMETERS_ALL PSP , --
13090: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
13091: PO_VENDORS POV,
13092: PO_HEADERS_INTERFACE PHI
13093: WHERE PLI.LINE_NUM = x_po_line_num
13094: AND PLI.shipment_num is not null

Line 13211: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --

13207: PO_REQUISITION_LINES_ALL PRL, --
13208: MTL_SYSTEM_ITEMS MSI ,
13209: PO_LINE_TYPES PLT ,
13210: PO_SYSTEM_PARAMETERS_ALL PSP , --
13211: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
13212: PO_VENDORS POV,
13213: PO_HEADERS_INTERFACE PHI
13214: WHERE PLI.LINE_NUM = x_po_line_num
13215: AND PLI.shipment_num is not null

Line 13339: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --

13335: --bug 1942696 hr_location changes to reflect the new view
13336: MTL_SYSTEM_ITEMS MSI ,
13337: PO_LINE_TYPES PLT ,
13338: PO_SYSTEM_PARAMETERS_ALL PSP , --
13339: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
13340: PO_VENDORS POV,
13341: PO_HEADERS_INTERFACE PHI
13342: WHERE PLI.LINE_NUM = x_po_line_num
13343: AND PLI.shipment_num is not null

Line 14072: FROM financials_system_params_all --

14068:
14069: begin
14070: SELECT inventory_organization_id
14071: INTO x_inv_org_id
14072: FROM financials_system_params_all --
14073: WHERE NVL(org_id, -99) = NVL(p_purchasing_ou_id, -99); --
14074:
14075: select item_id
14076: into x_item_id

Line 14824: from financials_system_params_all req_fsp

14820: END IF;
14821:
14822: select req_fsp.set_of_books_id
14823: into l_req_ou_sob_id
14824: from financials_system_params_all req_fsp
14825: where req_fsp.org_id = p_requesting_ou_id; --
14826:
14827: l_progress := '010';
14828: select po_fsp.set_of_books_id

Line 14830: from financials_system_params_all po_fsp

14826:
14827: l_progress := '010';
14828: select po_fsp.set_of_books_id
14829: into l_po_ou_sob_id
14830: from financials_system_params_all po_fsp
14831: where po_fsp.org_id = p_purchasing_ou_id; --
14832:
14833: IF l_req_ou_sob_id = l_po_ou_sob_id THEN
14834: x_rate := NULL;