APPS.AP_APXKIRKI_XMLP_PKG dependencies on AP_INVOICE_LINES

Line 472: AP_INVOICE_LINES LINES

468: SELECT
469: count(*)
470: INTO L_TOTAL_LINES
471: FROM
472: AP_INVOICE_LINES LINES
473: WHERE TRUNC(LINES.CREATION_DATE) <= TO_DATE(C_END_DATE
474: ,'DD/MM/YYYY');
475: SELECT
476: count(( BATCH_ID )),

Line 846: AP_INVOICE_LINES LINES,

842: TRUNC(INV.CREATION_DATE) INV_CREATION_DATE,
843: NVL(INVOICE_AMOUNT
844: ,0) INV_AMOUNT
845: FROM
846: AP_INVOICE_LINES LINES,
847: AP_INVOICES INV,
848: AP_INVOICE_DISTRIBUTIONS DIST
849: WHERE INV.INVOICE_ID = LINES.INVOICE_ID
850: AND LINES.INVOICE_ID = DIST.INVOICE_ID

Line 1153: AP_INVOICE_LINES LINES

1149: SELECT
1150: count(*)
1151: INTO L_NEW_LINES
1152: FROM
1153: AP_INVOICE_LINES LINES
1154: WHERE TRUNC(LINES.CREATION_DATE) >= TO_DATE(C_START_DATE
1155: ,'DD/MM/YYYY')
1156: AND TRUNC(LINES.CREATION_DATE) <= TO_DATE(C_END_DATE
1157: ,'DD/MM/YYYY');