DBA Data[Home] [Help]

APPS.PO_RETROACTIVE_PRICING_PVT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 251: po_headers_archive_all poha,financials_system_params_all fsp

247: poh.po_header_id,
248: poh.authorization_status, poh.revision_num,
249: poha.revision_num
250: from po_headers_all poh, po_lines_all pol, po_line_locations_all poll,
251: po_headers_archive_all poha,financials_system_params_all fsp
252: where pol.from_line_id = l_po_line_id
253: and poh.po_header_id = pol.po_header_id
254: and poh.org_id = fsp.org_id -- -- Bug 3573266
255: and nvl(fsp.purch_encumbrance_flag,'N') = 'N' -- Bug 3573266

Line 361: financials_system_params_all fsp

357: poh.authorization_status, poh.revision_num,
358: poha.revision_num
359: from po_headers_all poh, po_lines_all pol, po_line_locations_all poll,
360: po_headers_archive_all poha, po_document_types_all_b pdt,
361: financials_system_params_all fsp
362: where pol.from_line_id = l_po_line_id
363: and poh.po_header_id = pol.po_header_id
364: and poh.org_id = fsp.org_id -- -- Bug 3573266
365: and nvl(fsp.purch_encumbrance_flag,'N') = 'N' -- Bug 3573266

Line 435: financials_system_params_all fsp

431: FROM po_headers_all poh,
432: po_lines_all pol,
433: po_line_locations_all poll,
434: po_headers_archive_all poha,
435: financials_system_params_all fsp
436: WHERE pol.Contract_id = l_po_header_id
437: AND pol.from_header_id IS NULL
438: AND poh.po_header_id = pol.po_header_id
439: AND poh.org_id = fsp.org_id

Line 500: financials_system_params_all fsp

496: po_lines_all pol,
497: po_line_locations_all poll,
498: po_headers_archive_all poha,
499: po_document_types_all_b pdt,
500: financials_system_params_all fsp
501: WHERE pol.Contract_id = l_po_header_id
502: AND pol.from_header_id IS NULL
503: AND poh.po_header_id = pol.po_header_id
504: AND poh.org_id = fsp.org_id

Line 784: 'financials_system_params_all fsp, ' ; --

780: 'poh.global_agreement_flag ' ||
781: 'from po_headers_all poh, ' ||
782: 'po_lines pol, ' ||
783: 'mtl_system_items msi, ' ||
784: 'financials_system_params_all fsp, ' ; --
785: l_sql_str1 := 'mtl_categories mca ' ||
786: 'where poh.type_lookup_code = ''BLANKET'' ' ||
787: --Bug 4176111: Use a dynamic query string to change the retroactive date clause
788: l_retro_date_clause || --

Line 4692: financials_system_params_all fsp

4688: SELECT distinct 'Y'
4689: INTO l_account_valid
4690: FROM gl_code_combinations gcc,
4691: gl_sets_of_books sob,
4692: financials_system_params_all fsp
4693: WHERE gcc.code_combination_id = l_retroprice_adj_account_id
4694: AND gcc.enabled_flag = 'Y'
4695: AND trunc(SYSDATE) BETWEEN
4696: trunc(nvl(start_date_active,SYSDATE - 1) )