APPS.POA_EDW_SUP_PERF_F_C dependencies on PO_LINE_LOCATIONS_ALL

Line 580: from rcv_transactions rcv, po_line_locations_all pll

576: BEGIN
577:
578: insert into poa_edw_sup_perf_inc(primary_key, seq_id)
579: select rcv.po_line_location_id, p_seq_id
580: from rcv_transactions rcv, po_line_locations_all pll
581: where rcv.po_line_location_id = pll.line_location_id
582: and rcv.last_update_date between g_push_from_date and
583: g_push_to_date
584: group by rcv.po_line_location_id

Line 632: po_line_locations_all pll,

628: INSERT
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,

Line 708: po_line_locations_all pll,

704: Collection_Status
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