APPS.AP_APXKIRKI_XMLP_PKG dependencies on AP_INVOICES

Line 484: AP_INVOICES

480: ,NVL(INVOICE_AMOUNT
481: ,0)))
482: INTO L_TOTAL_BATCHES,L_TOTAL_INVOICES,L_TOTAL_INVOICES_DLR
483: FROM
484: AP_INVOICES
485: WHERE TRUNC(CREATION_DATE) <= TO_DATE(C_END_DATE
486: ,'DD/MM/YYYY');
487: SELECT
488: NVL(SUM(DECODE(AP_HOLDS.HOLD_LOOKUP_CODE

Line 496: ,NVL(AP_INVOICES.BASE_AMOUNT

492: ,0),
493: NVL(SUM(DECODE(AP_HOLDS.HOLD_LOOKUP_CODE
494: ,NULL
495: ,0
496: ,NVL(AP_INVOICES.BASE_AMOUNT
497: ,AP_INVOICES.INVOICE_AMOUNT)))
498: ,0)
499: INTO L_TOTAL_INVOICE_HOLDS,L_TOTAL_INVOICE_HOLDS_DLR
500: FROM

Line 497: ,AP_INVOICES.INVOICE_AMOUNT)))

493: NVL(SUM(DECODE(AP_HOLDS.HOLD_LOOKUP_CODE
494: ,NULL
495: ,0
496: ,NVL(AP_INVOICES.BASE_AMOUNT
497: ,AP_INVOICES.INVOICE_AMOUNT)))
498: ,0)
499: INTO L_TOTAL_INVOICE_HOLDS,L_TOTAL_INVOICE_HOLDS_DLR
500: FROM
501: AP_INVOICES,

Line 501: AP_INVOICES,

497: ,AP_INVOICES.INVOICE_AMOUNT)))
498: ,0)
499: INTO L_TOTAL_INVOICE_HOLDS,L_TOTAL_INVOICE_HOLDS_DLR
500: FROM
501: AP_INVOICES,
502: AP_HOLDS,
503: AP_HOLD_CODES
504: WHERE AP_INVOICES.INVOICE_ID = AP_HOLDS.INVOICE_ID
505: AND AP_HOLDS.HOLD_LOOKUP_CODE = AP_HOLD_CODES.HOLD_LOOKUP_CODE

Line 504: WHERE AP_INVOICES.INVOICE_ID = AP_HOLDS.INVOICE_ID

500: FROM
501: AP_INVOICES,
502: AP_HOLDS,
503: AP_HOLD_CODES
504: WHERE AP_INVOICES.INVOICE_ID = AP_HOLDS.INVOICE_ID
505: AND AP_HOLDS.HOLD_LOOKUP_CODE = AP_HOLD_CODES.HOLD_LOOKUP_CODE
506: AND AP_HOLD_CODES.HOLD_TYPE = 'INVOICE HOLD REASON'
507: AND AP_HOLDS.RELEASE_LOOKUP_CODE IS NULL
508: AND TRUNC(AP_INVOICES.CREATION_DATE) <= TO_DATE(C_END_DATE

Line 508: AND TRUNC(AP_INVOICES.CREATION_DATE) <= TO_DATE(C_END_DATE

504: WHERE AP_INVOICES.INVOICE_ID = AP_HOLDS.INVOICE_ID
505: AND AP_HOLDS.HOLD_LOOKUP_CODE = AP_HOLD_CODES.HOLD_LOOKUP_CODE
506: AND AP_HOLD_CODES.HOLD_TYPE = 'INVOICE HOLD REASON'
507: AND AP_HOLDS.RELEASE_LOOKUP_CODE IS NULL
508: AND TRUNC(AP_INVOICES.CREATION_DATE) <= TO_DATE(C_END_DATE
509: ,'DD/MM/YYYY');
510: SELECT
511: count(*),
512: NVL(SUM(NVL(CLEARED_BASE_AMOUNT

Line 648: AP_INVOICES INV

644: count(*)
645: INTO L_TOTAL_SCHEDULED
646: FROM
647: AP_PAYMENT_SCHEDULES PAY,
648: AP_INVOICES INV
649: WHERE PAY.INVOICE_ID = INV.INVOICE_ID
650: AND TRUNC(INV.CREATION_DATE) <= TO_DATE(C_END_DATE
651: ,'DD/MM/YYYY');
652: SELECT

Line 723: AP_INVOICES

719: ,0)),
720: TRUNC(CREATION_DATE)
721: INTO L_INVOICE_AMOUNT,L_CREATION_DATE
722: FROM
723: AP_INVOICES
724: WHERE INVOICE_ID = C1.INVOICE_ID;
725: IF L_CREATION_DATE <= TO_DATE(C_END_DATE
726: ,'DD/MM/YYYY') THEN
727: L_TOTAL_MH := L_TOTAL_MH + 1;

Line 773: AP_INVOICES

769: ,0)),
770: TRUNC(CREATION_DATE)
771: INTO L_INVOICE_AMOUNT,L_CREATION_DATE
772: FROM
773: AP_INVOICES
774: WHERE INVOICE_ID = C1.MATCHED_INVOICE_ID;
775: IF L_CREATION_DATE <= TO_DATE(C_END_DATE
776: ,'DD/MM/YYYY') THEN
777: L_TOTAL_MATCHED := L_TOTAL_MATCHED + 1;

Line 820: AP_INVOICES INV

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
824: DIS.INVOICE_ID,

Line 847: AP_INVOICES INV,

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
851: AND LINES.LINE_NUMBER = DIST.INVOICE_LINE_NUMBER

Line 1108: AP_INVOICES

1104: nvl(count(( BATCH_ID )),
1105: 0)
1106: INTO L_NEW_INVOICES,L_TOTAL_DLR,L_BATCHES
1107: FROM
1108: AP_INVOICES
1109: WHERE TRUNC(CREATION_DATE) >= TRUNC(TO_DATE(C_START_DATE
1110: ,'DD/MM/YYYY'))
1111: AND TRUNC(CREATION_DATE) <= TRUNC(TO_DATE(C_END_DATE
1112: ,'DD/MM/YYYY'));

Line 1127: AP_INVOICES I,

1123: ,I.INVOICE_AMOUNT)))
1124: ,0)
1125: INTO L_NEW_ON_HOLD,L_NEW_HOLD_DLR
1126: FROM
1127: AP_INVOICES I,
1128: AP_HOLDS H,
1129: AP_HOLD_CODES HC
1130: WHERE I.INVOICE_ID = H.INVOICE_ID
1131: AND H.HOLD_LOOKUP_CODE = HC.HOLD_LOOKUP_CODE

Line 1143: AP_INVOICES INV

1139: count(*)
1140: INTO L_PAYMENT_SCHEDULES
1141: FROM
1142: AP_PAYMENT_SCHEDULES PAY,
1143: AP_INVOICES INV
1144: WHERE PAY.INVOICE_ID = INV.INVOICE_ID
1145: AND TRUNC(INV.CREATION_DATE) >= TO_DATE(C_START_DATE
1146: ,'DD/MM/YYYY')
1147: AND TRUNC(INV.CREATION_DATE) <= TO_DATE(C_END_DATE