DBA Data[Home] [Help]

APPS.POA_EDW_SUP_PERF_F_C dependencies on PO_HEADERS_ALL

Line 633: po_headers_all poh

629: into poa_edw_sup_perf_inc(primary_key, seq_id)
630: SELECT pll.line_location_id, l_seq_id
631: FROM po_lines_all pol,
632: po_line_locations_all pll,
633: po_headers_all poh
634: WHERE poh.po_header_id = pll.po_header_id
635: AND pol.po_line_id = pll.po_line_id
636: AND (greatest(pol.last_update_date,pll.last_update_date,
637: poh.last_update_date)

Line 709: PO_HEADERS_ALL POH,

705: from POA_EDW_SUP_PERF_FSTG
706: where COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR
707: COLLECTION_STATUS = 'INVALID CURRENCY') fstg,
708: po_line_locations_all pll,
709: PO_HEADERS_ALL POH,
710: GL_SETS_OF_BOOKS GSOB,
711: FINANCIALS_SYSTEM_PARAMS_ALL FSP
712: WHERE fstg.Line_location_id = pll.line_location_id
713: AND PLL.PO_HEADER_ID = POH.PO_HEADER_ID