APPS.AP_APXKIRKI_XMLP_PKG dependencies on AP_HOLDS

Line 488: NVL(SUM(DECODE(AP_HOLDS.HOLD_LOOKUP_CODE

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
489: ,NULL
490: ,0
491: ,1))
492: ,0),

Line 493: NVL(SUM(DECODE(AP_HOLDS.HOLD_LOOKUP_CODE

489: ,NULL
490: ,0
491: ,1))
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)))

Line 502: AP_HOLDS,

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
506: AND AP_HOLD_CODES.HOLD_TYPE = 'INVOICE HOLD REASON'

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 505: AND AP_HOLDS.HOLD_LOOKUP_CODE = AP_HOLD_CODES.HOLD_LOOKUP_CODE

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
509: ,'DD/MM/YYYY');

Line 507: AND AP_HOLDS.RELEASE_LOOKUP_CODE IS NULL

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
509: ,'DD/MM/YYYY');
510: SELECT
511: count(*),

Line 710: AP_HOLDS H,

706: BEGIN
707: FOR c1 IN (SELECT
708: H.INVOICE_ID
709: FROM
710: AP_HOLDS H,
711: AP_HOLD_CODES HC
712: WHERE RELEASE_LOOKUP_CODE is null
713: AND H.HOLD_LOOKUP_CODE = HC.HOLD_LOOKUP_CODE
714: AND HC.HOLD_TYPE = 'MATCHING HOLD REASON') LOOP

Line 1128: AP_HOLDS H,

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
1132: AND TRUNC(I.CREATION_DATE) >= TO_DATE(C_START_DATE

Line 2015: AP_HOLDS H,

2011: SELECT
2012: count(( INVOICE_ID ))
2013: INTO L_INVOICE_COUNT
2014: FROM
2015: AP_HOLDS H,
2016: AP_HOLD_CODES HC
2017: WHERE H.RELEASE_LOOKUP_CODE is null
2018: AND H.HOLD_LOOKUP_CODE = HC.HOLD_LOOKUP_CODE
2019: AND HC.HOLD_TYPE = 'MATCHING HOLD REASON';