eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JE_JEFILPIP_XMLP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 267: SQL_DISTRIBUTIONS := 'and not exists' || '((select aid1.invoice_id from ap_invoice_distributions aid1' || ' where aid1.invoice_id = id.invoice_id';

263: INTO ENCUMBRANCE_FLAG
264: FROM
265: FINANCIALS_SYSTEM_PARAMETERS;
266: IF P_MATCH_STATUS_FLAG = 'A' THEN
267: SQL_DISTRIBUTIONS := 'and not exists' || '((select aid1.invoice_id from ap_invoice_distributions aid1' || ' where aid1.invoice_id = id.invoice_id';
268: IF NVL(ENCUMBRANCE_FLAG,'N') = 'Y' THEN
269: SQL_DISTRIBUTIONS := SQL_DISTRIBUTIONS || ' and nvl(aid1.match_status_flag,''N'') <> ''A'') ';
270: END IF;
271: IF NVL(ENCUMBRANCE_FLAG

Line 276: || ' and aih1.release_lookup_code is null))' || 'and exists' || '(select null from ap_invoice_distributions aid2' || ' where aid2.invoice_id = id.invoice_id)';

272: ,'N') = 'N' THEN
273: SQL_DISTRIBUTIONS := SQL_DISTRIBUTIONS || ' AND nvl(aid1.match_status_flag,''N'') not in (''A'', ''T'')) ';
274: END IF;
275: SQL_DISTRIBUTIONS := SQL_DISTRIBUTIONS || ' UNION' || ' (select aih1.invoice_id from ap_holds aih1' || ' where aih1.invoice_id = id.invoice_id'
276: || ' and aih1.release_lookup_code is null))' || 'and exists' || '(select null from ap_invoice_distributions aid2' || ' where aid2.invoice_id = id.invoice_id)';
277: END IF;
278: IF P_MATCH_STATUS_FLAG = 'N' THEN
279: SQL_DISTRIBUTIONS := 'and exists' || '((select aid2.invoice_id from ap_invoice_distributions aid2' || ' where aid2.invoice_id = id.invoice_id';
280: IF NVL(ENCUMBRANCE_FLAG,'N') = 'Y' THEN

Line 279: SQL_DISTRIBUTIONS := 'and exists' || '((select aid2.invoice_id from ap_invoice_distributions aid2' || ' where aid2.invoice_id = id.invoice_id';

275: SQL_DISTRIBUTIONS := SQL_DISTRIBUTIONS || ' UNION' || ' (select aih1.invoice_id from ap_holds aih1' || ' where aih1.invoice_id = id.invoice_id'
276: || ' and aih1.release_lookup_code is null))' || 'and exists' || '(select null from ap_invoice_distributions aid2' || ' where aid2.invoice_id = id.invoice_id)';
277: END IF;
278: IF P_MATCH_STATUS_FLAG = 'N' THEN
279: SQL_DISTRIBUTIONS := 'and exists' || '((select aid2.invoice_id from ap_invoice_distributions aid2' || ' where aid2.invoice_id = id.invoice_id';
280: IF NVL(ENCUMBRANCE_FLAG,'N') = 'Y' THEN
281: SQL_DISTRIBUTIONS := SQL_DISTRIBUTIONS || ' and nvl(aid2.match_status_flag,''N'') <> ''A'')';
282: END IF;
283: IF NVL(ENCUMBRANCE_FLAG

Line 381: (select null from ap_invoice_distributions id, ap_invoice_distributions ppd, ap_invoices pp' || ', ap_payment_schedules ppps, ap_invoice_payments ppip, ap_checks c ' || 'where id.invoice_id = ps.invoice_id

377:
378: SQL_PAYMENTS3 := SQL_PAYMENTS3 || 'and ( nvl(ps.amount_remaining,0)<>0 or ' || '(not exists (select null from ap_invoice_payments ip, ap_checks c, xla_transaction_entities aae, xla_ae_headers ach, xla_events xev ' || 'where
379: ip.invoice_id=ps.invoice_id and ps.payment_num=ip.payment_num and ip.check_id=c.check_id and c.void_date is null ' || 'and c.check_id = aae.source_id_int_1(+) and aae.ENTITY_CODE = ''AP_PAYMENTS'' and
380: aae.ENTITY_ID = ach.ENTITY_ID ' || 'and xev.ENTITY_ID = aae.ENTITY_ID and xev.EVENT_TYPE_CODE in (''PAYMENT CREATED'', ''PAYMENT CLEARED'', ''REFUND RECORDED'') ' || SQL_PAYMENTS2 || ') AND ' || 'not exists
381: (select null from ap_invoice_distributions id, ap_invoice_distributions ppd, ap_invoices pp' || ', ap_payment_schedules ppps, ap_invoice_payments ppip, ap_checks c ' || 'where id.invoice_id = ps.invoice_id
382: and id.line_type_lookup_code = ''PREPAY''
383: and id.PREPAY_DISTRIBUTION_ID = ppd.INVOICE_DISTRIBUTION_ID ' || 'and ppd.invoice_id = pp.invoice_id and pp.invoice_type_lookup_code = ''PREPAYMENT'' and pp.invoice_id = ppip.invoice_id ' || 'and ppps.invoice_id = pp.invoice_id and
384: ppps.payment_num = ppip.payment_num and ppip.check_id = c.check_id ' || 'and c.void_date is null ' || L_SQL_PAY2_SUB || ') ) ' || 'or exists (select null from ap_invoice_payments ip, ap_checks c ' || ' where
385: ps.invoice_id=ip.invoice_id and ip.check_id=c.check_id and c.void_date is null and ps.payment_num=ip.payment_num ' || ' and trunc(ip.accounting_date) >=''' || TO_CHAR(L_START_DATE) || '''' || '

Line 386: and trunc(ip.accounting_date) <=''' || TO_CHAR(P_CUT_DATE) || ''') ' || 'or exists (select null from ap_invoice_distributions id, ap_invoice_distributions ppd, ap_invoices pp' || ', ap_payment_schedules ppps,

382: and id.line_type_lookup_code = ''PREPAY''
383: and id.PREPAY_DISTRIBUTION_ID = ppd.INVOICE_DISTRIBUTION_ID ' || 'and ppd.invoice_id = pp.invoice_id and pp.invoice_type_lookup_code = ''PREPAYMENT'' and pp.invoice_id = ppip.invoice_id ' || 'and ppps.invoice_id = pp.invoice_id and
384: ppps.payment_num = ppip.payment_num and ppip.check_id = c.check_id ' || 'and c.void_date is null ' || L_SQL_PAY2_SUB || ') ) ' || 'or exists (select null from ap_invoice_payments ip, ap_checks c ' || ' where
385: ps.invoice_id=ip.invoice_id and ip.check_id=c.check_id and c.void_date is null and ps.payment_num=ip.payment_num ' || ' and trunc(ip.accounting_date) >=''' || TO_CHAR(L_START_DATE) || '''' || '
386: and trunc(ip.accounting_date) <=''' || TO_CHAR(P_CUT_DATE) || ''') ' || 'or exists (select null from ap_invoice_distributions id, ap_invoice_distributions ppd, ap_invoices pp' || ', ap_payment_schedules ppps,
387: ap_invoice_payments ppip, ap_checks c ' || 'where id.invoice_id = ps.invoice_id and id.line_type_lookup_code = ''PREPAY'' and id.PREPAY_DISTRIBUTION_ID = ppd.INVOICE_DISTRIBUTION_ID ' || 'and ppd.invoice_id = pp.invoice_id
388: and pp.invoice_type_lookup_code = ''PREPAYMENT'' and pp.invoice_id = ppip.invoice_id ' || 'and ppps.invoice_id = pp.invoice_id and ppps.payment_num = ppip.payment_num and ppip.check_id = c.check_id ' || 'and c.void_date is null
389: and trunc(id.accounting_date) >=''' || TO_CHAR(L_START_DATE) || '''' || ' and trunc(id.accounting_date) <=''' || TO_CHAR(P_CUT_DATE) || ''')) ';
390:

Line 394: SQL_PAYMENTS2 || ') AND ' || 'not exists (select null from ap_invoice_distributions id, ap_invoice_distributions ppd, ap_invoices pp' || ', ap_payment_schedules ppps, ap_invoice_payments ppip, ap_checks c ' ||

390:
391: SQL_PAYMENTS_FDP := SQL_PAYMENTS_FDP || 'and ( nvl(ps.amount_remaining,0)<>0 or ' || '(not exists (select null from ap_invoice_payments ip, ap_checks c, xla_transaction_entities aae,
392: xla_ae_headers ach, xla_events xev ' || 'where ip.invoice_id=ps.invoice_id and ps.payment_num=ip.payment_num and ip.check_id=c.check_id and c.void_date is null ' || 'and c.check_id = aae.source_id_int_1(+)
393: and aae.ENTITY_CODE = ''AP_PAYMENTS'' and aae.ENTITY_ID = ach.ENTITY_ID ' || 'and xev.ENTITY_ID = aae.ENTITY_ID and xev.EVENT_TYPE_CODE in (''PAYMENT CREATED'', ''PAYMENT CLEARED'', ''REFUND RECORDED'') ' ||
394: SQL_PAYMENTS2 || ') AND ' || 'not exists (select null from ap_invoice_distributions id, ap_invoice_distributions ppd, ap_invoices pp' || ', ap_payment_schedules ppps, ap_invoice_payments ppip, ap_checks c ' ||
395: 'where id.invoice_id = ps.invoice_id and id.line_type_lookup_code = ''PREPAY'' and id.PREPAY_DISTRIBUTION_ID = ppd.INVOICE_DISTRIBUTION_ID ' || 'and ppd.invoice_id = pp.invoice_id and pp.invoice_type_lookup_code = ''PREPAYMENT''
396: and pp.invoice_id = ppip.invoice_id ' || 'and ppps.invoice_id = pp.invoice_id and ppps.payment_num = ppip.payment_num and ppip.check_id = c.check_id ' || 'and c.void_date is null ' || L_SQL_PAY2_SUB || ')) ' ||
397: 'or exists (select null from ap_invoice_payments ip, ap_checks c ' || ' where ps.invoice_id=ip.invoice_id and ip.check_id=c.check_id and c.void_date is null and ps.payment_num=ip.payment_num ' || '
398: and trunc(ip.accounting_date) <=''' || TO_CHAR(P_CUT_DATE) || '''' || ' and c.future_pay_due_date is not null ' || ' and c.status_lookup_code = ''ISSUED'')) ';

Line 410: || ') AND ' || ' not exists (select null from ap_invoice_distributions id, ap_invoice_distributions ppd, ap_invoices pp' || ', ap_payment_schedules ppps, ap_invoice_payments ppip, ap_checks c ' || 'where id.invoice_id = ps.invoice_id

406:
407: SQL_PAYMENTS3 := SQL_PAYMENTS3 || 'and ( nvl(ps.amount_remaining,0)<>0 or ' || '(not exists (select null from ap_invoice_payments ip, ap_checks c, xla_transaction_entities aae, xla_ae_headers ach,
408: xla_events xev ' || 'where ip.invoice_id=ps.invoice_id and ps.payment_num=ip.payment_num and ip.check_id=c.check_id and c.void_date is null ' || 'and c.check_id = aae.source_id_int_1(+) and
409: aae.ENTITY_CODE = ''AP_PAYMENTS'' and aae.ENTITY_ID = ach.ENTITY_ID ' || 'and xev.ENTITY_ID = aae.ENTITY_ID and xev.EVENT_TYPE_CODE in (''PAYMENT CREATED'', ''PAYMENT CLEARED'', ''REFUND RECORDED'') ' || SQL_PAYMENTS2
410: || ') AND ' || ' not exists (select null from ap_invoice_distributions id, ap_invoice_distributions ppd, ap_invoices pp' || ', ap_payment_schedules ppps, ap_invoice_payments ppip, ap_checks c ' || 'where id.invoice_id = ps.invoice_id
411: and id.line_type_lookup_code = ''PREPAY'' and id.PREPAY_DISTRIBUTION_ID = ppd.INVOICE_DISTRIBUTION_ID ' || 'and ppd.invoice_id = pp.invoice_id and pp.invoice_type_lookup_code = ''PREPAYMENT'' and pp.invoice_id = ppip.invoice_id ' ||
412: 'and ppps.invoice_id = pp.invoice_id and ppps.payment_num = ppip.payment_num and ppip.check_id = c.check_id ' || 'and c.void_date is null ' || L_SQL_PAY2_SUB || ')) )';
413:
414: END IF;

Line 512: AP_INVOICE_DISTRIBUTIONS

508: SUM(NVL(BASE_AMOUNT
509: ,AMOUNT))
510: INTO DIST_TOTAL
511: FROM
512: AP_INVOICE_DISTRIBUTIONS
513: WHERE INVOICE_ID = P_INVOICE_ID;
514: EXCEPTION
515: WHEN NO_DATA_FOUND THEN
516: DIST_TOTAL := DIST_BASE_AMOUNT;

Line 587: AP_INVOICE_DISTRIBUTIONS_ALL ID,

583: ,ID.AMOUNT)) PREPAY_AMT,
584: SUM(ID.AMOUNT) INVPP_OPEN_AMOUNT,
585: MAX(ID.ACCOUNTING_DATE) INVPP_GL_DATE
586: FROM
587: AP_INVOICE_DISTRIBUTIONS_ALL ID,
588: AP_INVOICE_DISTRIBUTIONS_ALL PPD,
589: AP_INVOICES_ALL PP
590: WHERE ID.INVOICE_ID = P_INVOICE_ID
591: AND ( ( ID.LINE_TYPE_LOOKUP_CODE = 'PREPAY'

Line 588: AP_INVOICE_DISTRIBUTIONS_ALL PPD,

584: SUM(ID.AMOUNT) INVPP_OPEN_AMOUNT,
585: MAX(ID.ACCOUNTING_DATE) INVPP_GL_DATE
586: FROM
587: AP_INVOICE_DISTRIBUTIONS_ALL ID,
588: AP_INVOICE_DISTRIBUTIONS_ALL PPD,
589: AP_INVOICES_ALL PP
590: WHERE ID.INVOICE_ID = P_INVOICE_ID
591: AND ( ( ID.LINE_TYPE_LOOKUP_CODE = 'PREPAY'
592: AND ID.PREPAY_DISTRIBUTION_ID = PPD.INVOICE_DISTRIBUTION_ID ) )

Line 604: AP_INVOICE_DISTRIBUTIONS_ALL ID,

600: ,ID.AMOUNT)) PREPAY_AMT,
601: SUM(ID.AMOUNT) INVPP_OPEN_AMOUNT,
602: MAX(ID.ACCOUNTING_DATE) INVPP_GL_DATE
603: FROM
604: AP_INVOICE_DISTRIBUTIONS_ALL ID,
605: AP_INVOICE_DISTRIBUTIONS_ALL PPD,
606: AP_INVOICE_DISTRIBUTIONS_ALL AID,
607: AP_INVOICES_ALL PP
608: WHERE ID.INVOICE_ID = P_INVOICE_ID

Line 605: AP_INVOICE_DISTRIBUTIONS_ALL PPD,

601: SUM(ID.AMOUNT) INVPP_OPEN_AMOUNT,
602: MAX(ID.ACCOUNTING_DATE) INVPP_GL_DATE
603: FROM
604: AP_INVOICE_DISTRIBUTIONS_ALL ID,
605: AP_INVOICE_DISTRIBUTIONS_ALL PPD,
606: AP_INVOICE_DISTRIBUTIONS_ALL AID,
607: AP_INVOICES_ALL PP
608: WHERE ID.INVOICE_ID = P_INVOICE_ID
609: AND ID.LINE_TYPE_LOOKUP_CODE = 'TAX'

Line 606: AP_INVOICE_DISTRIBUTIONS_ALL AID,

602: MAX(ID.ACCOUNTING_DATE) INVPP_GL_DATE
603: FROM
604: AP_INVOICE_DISTRIBUTIONS_ALL ID,
605: AP_INVOICE_DISTRIBUTIONS_ALL PPD,
606: AP_INVOICE_DISTRIBUTIONS_ALL AID,
607: AP_INVOICES_ALL PP
608: WHERE ID.INVOICE_ID = P_INVOICE_ID
609: AND ID.LINE_TYPE_LOOKUP_CODE = 'TAX'
610: AND AID.LINE_TYPE_LOOKUP_CODE = 'PREPAY'

Line 710: AP_INVOICE_DISTRIBUTIONS AID

706: SELECT
707: count(*)
708: INTO A_COUNT
709: FROM
710: AP_INVOICE_DISTRIBUTIONS AID
711: WHERE AID.INVOICE_ID = P_INVOICE_ID
712: AND NVL(AID.MATCH_STATUS_FLAG
713: ,'N') <> 'A';
714: IF (A_COUNT = 0) THEN