DBA Data[Home] [Help]

APPS.JG_JGZZSRCR_XMLP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 365: '((select aid1.invoice_id from ap_invoice_distributions aid1' ||

361: ,P_REPORTING_ENTITY_ID
362: ,ORG_ID);
363: IF P_MATCH_STATUS_FLAG_V = 'A' THEN
364: SQL_DISTRIBUTIONS := 'and not exists' ||
365: '((select aid1.invoice_id from ap_invoice_distributions aid1' ||
366: ' where aid1.invoice_id = id.invoice_id';
367: IF NVL(ENCUMBRANCE_FLAG
368: ,'N') = 'Y' THEN
369: SQL_DISTRIBUTIONS := SQL_DISTRIBUTIONS || ' and nvl(aid1.match_status_flag,''N'') <> ''A'') ';

Line 379: 'and exists' || '(select null from ap_invoice_distributions aid2' ||

375: SQL_DISTRIBUTIONS := SQL_DISTRIBUTIONS || ' UNION' ||
376: ' (select aih1.invoice_id from ap_holds aih1' ||
377: ' where aih1.invoice_id = id.invoice_id' ||
378: ' and aih1.release_lookup_code is null))' ||
379: 'and exists' || '(select null from ap_invoice_distributions aid2' ||
380: ' where aid2.invoice_id = id.invoice_id)';
381: END IF;
382: IF P_MATCH_STATUS_FLAG_V = 'N' THEN
383: SQL_DISTRIBUTIONS := 'and exists' || '((select aid2.invoice_id from ap_invoice_distributions aid2' ||

Line 383: SQL_DISTRIBUTIONS := 'and exists' || '((select aid2.invoice_id from ap_invoice_distributions aid2' ||

379: 'and exists' || '(select null from ap_invoice_distributions aid2' ||
380: ' where aid2.invoice_id = id.invoice_id)';
381: END IF;
382: IF P_MATCH_STATUS_FLAG_V = 'N' THEN
383: SQL_DISTRIBUTIONS := 'and exists' || '((select aid2.invoice_id from ap_invoice_distributions aid2' ||
384: ' where aid2.invoice_id = id.invoice_id';
385: IF NVL(ENCUMBRANCE_FLAG
386: ,'N') = 'Y' THEN
387: SQL_DISTRIBUTIONS := SQL_DISTRIBUTIONS || ' and nvl(aid2.match_status_flag,''N'') <> ''A'')';

Line 544: AP_INVOICE_DISTRIBUTIONS

540: SUM(NVL(BASE_AMOUNT
541: ,AMOUNT))
542: INTO DIST_TOTAL
543: FROM
544: AP_INVOICE_DISTRIBUTIONS
545: WHERE INVOICE_ID = INVOICE_ID_v;
546: EXCEPTION
547: WHEN NO_DATA_FOUND THEN
548: DIST_TOTAL := DIST_BASE_AMOUNT;

Line 627: AP_INVOICE_DISTRIBUTIONS ID,

623: SUM(ID.AMOUNT),
624: MAX(ID.ACCOUNTING_DATE)
625: INTO CP_INVPP_OPEN_BASE,CP_INVPP_OPEN_AMOUNT,CP_INVPP_GL_DATE
626: FROM
627: AP_INVOICE_DISTRIBUTIONS ID,
628: AP_INVOICE_DISTRIBUTIONS PPD,
629: AP_INVOICES PP
630: WHERE ID.INVOICE_ID = INVOICE_ID_V
631: AND ( ( ID.LINE_TYPE_LOOKUP_CODE = 'PREPAY'

Line 628: AP_INVOICE_DISTRIBUTIONS PPD,

624: MAX(ID.ACCOUNTING_DATE)
625: INTO CP_INVPP_OPEN_BASE,CP_INVPP_OPEN_AMOUNT,CP_INVPP_GL_DATE
626: FROM
627: AP_INVOICE_DISTRIBUTIONS ID,
628: AP_INVOICE_DISTRIBUTIONS PPD,
629: AP_INVOICES PP
630: WHERE ID.INVOICE_ID = INVOICE_ID_V
631: AND ( ( ID.LINE_TYPE_LOOKUP_CODE = 'PREPAY'
632: AND ID.PREPAY_DISTRIBUTION_ID = PPD.INVOICE_DISTRIBUTION_ID )

Line 638: AP_INVOICE_DISTRIBUTIONS SAMEID

634: AND exists (
635: SELECT
636: 1
637: FROM
638: AP_INVOICE_DISTRIBUTIONS SAMEID
639: WHERE SAMEID.INVOICE_ID = INVOICE_ID
640: AND SAMEID.LINE_TYPE_LOOKUP_CODE = 'PREPAY'
641: AND SAMEID.PREPAY_DISTRIBUTION_ID = PPD.INVOICE_DISTRIBUTION_ID
642: AND SAMEID.INVOICE_DISTRIBUTION_ID = ID.PREPAY_TAX_PARENT_ID ) ) )

Line 742: AP_INVOICE_DISTRIBUTIONS AID

738: SELECT
739: count(*)
740: INTO A_COUNT
741: FROM
742: AP_INVOICE_DISTRIBUTIONS AID
743: WHERE AID.INVOICE_ID = INVOICE_ID_v
744: AND NVL(AID.MATCH_STATUS_FLAG
745: ,'N') <> 'A';
746: IF (A_COUNT = 0) THEN