APPS.AP_APXKIRKI_XMLP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 465: AP_INVOICE_DISTRIBUTIONS DIS

461: SELECT
462: count(*)
463: INTO L_TOTAL_DISTS
464: FROM
465: AP_INVOICE_DISTRIBUTIONS DIS
466: WHERE TRUNC(DIS.CREATION_DATE) <= TO_DATE(C_END_DATE
467: ,'DD/MM/YYYY');
468: SELECT
469: count(*)

Line 763: AP_INVOICE_DISTRIBUTIONS

759: FOR c1 IN (SELECT
760: DISTINCT
761: ( INVOICE_ID ) MATCHED_INVOICE_ID
762: FROM
763: AP_INVOICE_DISTRIBUTIONS
764: WHERE PO_DISTRIBUTION_ID is not null) LOOP
765: BEGIN
766: SELECT
767: NVL(BASE_AMOUNT

Line 819: AP_INVOICE_DISTRIBUTIONS DIS,

815: NVL(INV.BASE_AMOUNT
816: ,NVL(INVOICE_AMOUNT
817: ,0)) INV_AMOUNT
818: FROM
819: AP_INVOICE_DISTRIBUTIONS DIS,
820: AP_INVOICES INV
821: WHERE PAYMENT_STATUS_FLAG in ( 'P' , 'N' )
822: AND DIS.INVOICE_ID = INV.INVOICE_ID
823: GROUP BY

Line 848: AP_INVOICE_DISTRIBUTIONS DIST

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
851: AND LINES.LINE_NUMBER = DIST.INVOICE_LINE_NUMBER
852: AND PAYMENT_STATUS_FLAG in ( 'P' , 'N' )

Line 1162: AP_INVOICE_DISTRIBUTIONS DIS

1158: SELECT
1159: count(*)
1160: INTO L_NEW_DISTS
1161: FROM
1162: AP_INVOICE_DISTRIBUTIONS DIS
1163: WHERE TRUNC(DIS.CREATION_DATE) >= TO_DATE(C_START_DATE
1164: ,'DD/MM/YYYY')
1165: AND TRUNC(DIS.CREATION_DATE) <= TO_DATE(C_END_DATE
1166: ,'DD/MM/YYYY');