APPS.POA_EDW_ALINES_F_C dependencies on PO_LINES_ALL

Line 400: po_lines_all pol

396:
397: INSERT INTO poa_edw_alines_inc(primary_key, seq_id)
398: SELECT pol.po_line_id, l_seq_id
399: FROM po_headers_all poh,
400: po_lines_all pol
401: WHERE poh.type_lookup_code = 'BLANKET'
402: AND poh.approved_flag = 'Y'
403: AND poh.po_header_id = pol.po_header_id
404: AND greatest(poh.last_update_date, pol.last_update_date)

Line 467: po_lines_all pol,

463: gsob.currency_code)) From_Currency,
464: fstg.Collection_Status
465: FROM POA_EDW_ALINES_FSTG fstg,
466: PO_HEADERS_ALL POH,
467: po_lines_all pol,
468: GL_SETS_OF_BOOKS GSOB,
469: FINANCIALS_SYSTEM_PARAMS_ALL FSP
470: where (fstg.COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR
471: fstg.COLLECTION_STATUS = 'INVALID CURRENCY')