APPS.PO_RETROACTIVE_PRICING_PVT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 244: po_headers_archive_all poha,financials_system_params_all fsp

240: poh.po_header_id,
241: poh.authorization_status, poh.revision_num,
242: poha.revision_num
243: from po_headers_all poh, po_lines_all pol, po_line_locations_all poll,
244: po_headers_archive_all poha,financials_system_params_all fsp
245: where pol.from_line_id = l_po_line_id
246: and poh.po_header_id = pol.po_header_id
247: and poh.org_id = fsp.org_id -- -- Bug 3573266
248: and nvl(fsp.purch_encumbrance_flag,'N') = 'N' -- Bug 3573266

Line 342: financials_system_params_all fsp

338: poh.authorization_status, poh.revision_num,
339: poha.revision_num
340: from po_headers_all poh, po_lines_all pol, po_line_locations_all poll,
341: po_headers_archive_all poha, po_document_types_all_b pdt,
342: financials_system_params_all fsp
343: where pol.from_line_id = l_po_line_id
344: and poh.po_header_id = pol.po_header_id
345: and poh.org_id = fsp.org_id -- -- Bug 3573266
346: and nvl(fsp.purch_encumbrance_flag,'N') = 'N' -- Bug 3573266

Line 410: financials_system_params_all fsp

406: FROM po_headers_all poh,
407: po_lines_all pol,
408: po_line_locations_all poll,
409: po_headers_archive_all poha,
410: financials_system_params_all fsp
411: WHERE pol.Contract_id = l_po_header_id
412: AND pol.from_header_id IS NULL
413: AND poh.po_header_id = pol.po_header_id
414: AND poh.org_id = fsp.org_id

Line 475: financials_system_params_all fsp

471: po_lines_all pol,
472: po_line_locations_all poll,
473: po_headers_archive_all poha,
474: po_document_types_all_b pdt,
475: financials_system_params_all fsp
476: WHERE pol.Contract_id = l_po_header_id
477: AND pol.from_header_id IS NULL
478: AND poh.po_header_id = pol.po_header_id
479: AND poh.org_id = fsp.org_id

Line 758: 'financials_system_params_all fsp, ' ; --

754: 'poh.global_agreement_flag ' ||
755: 'from po_headers_all poh, ' ||
756: 'po_lines pol, ' ||
757: 'mtl_system_items msi, ' ||
758: 'financials_system_params_all fsp, ' ; --
759: l_sql_str1 := 'mtl_categories mca ' ||
760: 'where poh.type_lookup_code = ''BLANKET'' ' ||
761: --Bug 4176111: Use a dynamic query string to change the retroactive date clause
762: l_retro_date_clause || --

Line 4571: financials_system_params_all fsp

4567: SELECT distinct 'Y'
4568: INTO l_account_valid
4569: FROM gl_code_combinations gcc,
4570: gl_sets_of_books sob,
4571: financials_system_params_all fsp
4572: WHERE gcc.code_combination_id = l_retroprice_adj_account_id
4573: AND gcc.enabled_flag = 'Y'
4574: AND trunc(SYSDATE) BETWEEN
4575: trunc(nvl(start_date_active,SYSDATE - 1) )