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.GMS_COST_PLUS_EXTN dependencies on PA_CMT_UTILS

Line 353: , pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,

349: If l_choice in (2,3) then
350: /*OPEN P_DOC_ADJ FOR
351: select d.invoice_distribution_id dist_id -- AP Lines change
352: ,I.invoice_id header_id
353: , pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
354: I.invoice_id,
355: nvl(d.base_amount,d.amount),
356: 'N',
357: 'GMS', nvl(g.sla_ledger_cash_basis_flag,'N')) amount

Line 363: , ( pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,

359: , adl.burdenable_raw_cost burden
360: , adl.award_set_id award_set_id
361: , adl.adl_line_num adl_line_num
362:
363: , ( pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
364: I.invoice_id,
365: nvl(d.base_amount,d.amount),
366: 'N',
367: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) - NVL(adl.burdenable_raw_cost,0) ) diff_amount

Line 383: and pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,

379: ap_invoice_distributions D,
380: gms_award_distributions ADL,
381: GL_LEDGERS G
382: where i.invoice_id = d.invoice_id
383: and pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
384: I.invoice_id,
385: nvl(d.base_amount,d.amount),
386: 'N',
387: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N')) <> 0

Line 433: , pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,

429: IND_COMPILED_SET_ID
430: from
431: ( select d.invoice_distribution_id dist_id -- AP Lines change
432: ,I.invoice_id header_id
433: , pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
434: I.invoice_id,
435: nvl(d.base_amount,d.amount),
436: 'N',
437: 'GMS', nvl(g.sla_ledger_cash_basis_flag,'N')) amount

Line 443: , ( pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,

439: , adl.burdenable_raw_cost burden
440: , adl.award_set_id award_set_id
441: , adl.adl_line_num adl_line_num
442:
443: , ( pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
444: I.invoice_id,
445: nvl(d.base_amount,d.amount),
446: 'N',
447: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) - NVL(adl.burdenable_raw_cost,0) ) diff_amount

Line 463: and pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,

459: ap_invoice_distributions D,
460: gms_award_distributions ADL,
461: GL_LEDGERS G
462: where i.invoice_id = d.invoice_id
463: and pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
464: I.invoice_id,
465: nvl(d.base_amount,d.amount),
466: 'N',
467: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N')) <> 0

Line 493: , pa_cmt_utils.get_apdist_amt(APSAT.invoice_distribution_id,

489: )
490: union /* BUG 14216205 : Added the union for SAT */
491: select APSAT.invoice_distribution_id dist_id
492: ,I.invoice_id header_id
493: , pa_cmt_utils.get_apdist_amt(APSAT.invoice_distribution_id,
494: I.invoice_id,
495: nvl(APSAT.base_amount,APSAT.amount),
496: 'N',
497: 'GMS', nvl(g.sla_ledger_cash_basis_flag,'N')) amount

Line 502: , ( pa_cmt_utils.get_apdist_amt(APSAT.invoice_distribution_id,

498: , adl.burdenable_raw_cost burden
499: , adl.award_set_id award_set_id
500: , adl.adl_line_num adl_line_num
501:
502: , ( pa_cmt_utils.get_apdist_amt(APSAT.invoice_distribution_id,
503: I.invoice_id,
504: nvl(APSAT.base_amount,APSAT.amount),
505: 'N',
506: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) - NVL(adl.burdenable_raw_cost,0) ) diff_amount

Line 521: and pa_cmt_utils.get_apdist_amt(apsat.invoice_distribution_id,

517: AP_SELF_ASSESSED_TAX_DIST apsat,
518: gms_award_distributions ADL,
519: GL_LEDGERS G
520: where i.invoice_id = apsat.invoice_id
521: and pa_cmt_utils.get_apdist_amt(apsat.invoice_distribution_id,
522: I.invoice_id,
523: nvl(apsat.base_amount,apsat.amount),
524: 'N',
525: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N')) <> 0

Line 553: , pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,

549: ElsIf l_choice = 1 then
550: /*OPEN P_DOC_ADJ FOR
551: select d.invoice_distribution_id dist_id -- AP Lines change
552: ,I.invoice_id header_id
553: , pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
554: I.invoice_id,
555: nvl(d.base_amount,d.amount),
556: 'N',
557: 'GMS' ) amount

Line 562: , ( pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,

558: --, nvl(d.base_amount,d.amount) amount
559: , adl.burdenable_raw_cost burden
560: , adl.award_set_id award_set_id
561: , adl.adl_line_num adl_line_num
562: , ( pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
563: I.invoice_id,
564: nvl(d.base_amount,d.amount),
565: 'N',
566: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) - NVL(adl.burdenable_raw_cost,0) ) diff_amount

Line 582: and pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,

578: ap_invoice_distributions D,
579: gms_award_distributions ADL,
580: gl_ledgers g
581: where i.invoice_id = d.invoice_id
582: and pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
583: I.invoice_id,
584: nvl(d.base_amount,d.amount),
585: 'N',
586: 'GMS', nvl(g.sla_ledger_cash_basis_flag,'N')) <> 0

Line 627: , pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,

623: IND_COMPILED_SET_ID
624: from
625: ( select d.invoice_distribution_id dist_id -- AP Lines change
626: ,I.invoice_id header_id
627: , pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
628: I.invoice_id,
629: nvl(d.base_amount,d.amount),
630: 'N',
631: 'GMS' ) amount

Line 636: , ( pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,

632: --, nvl(d.base_amount,d.amount) amount
633: , adl.burdenable_raw_cost burden
634: , adl.award_set_id award_set_id
635: , adl.adl_line_num adl_line_num
636: , ( pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
637: I.invoice_id,
638: nvl(d.base_amount,d.amount),
639: 'N',
640: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) - NVL(adl.burdenable_raw_cost,0) ) diff_amount

Line 656: and pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,

652: ap_invoice_distributions D,
653: gms_award_distributions ADL,
654: gl_ledgers g
655: where i.invoice_id = d.invoice_id
656: and pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,
657: I.invoice_id,
658: nvl(d.base_amount,d.amount),
659: 'N',
660: 'GMS', nvl(g.sla_ledger_cash_basis_flag,'N')) <> 0

Line 682: , pa_cmt_utils.get_apdist_amt(apsat.invoice_distribution_id,

678:
679: union /* BUG 14216205 : Added the union for SAT */
680: select apsat.invoice_distribution_id dist_id
681: ,I.invoice_id header_id
682: , pa_cmt_utils.get_apdist_amt(apsat.invoice_distribution_id,
683: I.invoice_id,
684: nvl(apsat.base_amount,apsat.amount),
685: 'N',
686: 'GMS' ) amount

Line 690: , ( pa_cmt_utils.get_apdist_amt(apsat.invoice_distribution_id,

686: 'GMS' ) amount
687: , adl.burdenable_raw_cost burden
688: , adl.award_set_id award_set_id
689: , adl.adl_line_num adl_line_num
690: , ( pa_cmt_utils.get_apdist_amt(apsat.invoice_distribution_id,
691: I.invoice_id,
692: nvl(apsat.base_amount,apsat.amount),
693: 'N',
694: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) - NVL(adl.burdenable_raw_cost,0) ) diff_amount

Line 709: and pa_cmt_utils.get_apdist_amt(apsat.invoice_distribution_id,

705: AP_SELF_ASSESSED_TAX_DIST_ALL apsat,
706: gms_award_distributions ADL,
707: gl_ledgers g
708: where i.invoice_id = apsat.invoice_id
709: and pa_cmt_utils.get_apdist_amt(apsat.invoice_distribution_id,
710: I.invoice_id,
711: nvl(apsat.base_amount,apsat.amount),
712: 'N',
713: 'GMS', nvl(g.sla_ledger_cash_basis_flag,'N')) <> 0

Line 2773: and pa_cmt_utils.get_apdist_amt( apd.invoice_distribution_id,

2769: and nvl(adl.burdenable_raw_cost,0) <> 0
2770: and apd.expenditure_type = P_record.expenditure_type
2771: and ADL.award_set_id = APD.award_id
2772: AND G.LEDGER_ID = APD.SET_OF_BOOKS_ID
2773: and pa_cmt_utils.get_apdist_amt( apd.invoice_distribution_id,
2774: apd.invoice_id,
2775: nvl(apd.base_amount,apd.amount),
2776: 'N',
2777: 'GMS', nvl(g.sla_ledger_cash_basis_flag,'N') ) <> 0

Line 2806: and PA_CMT_UTILS.get_apdist_amt( APSAT.INVOICE_DISTRIBUTION_ID,

2802: and NVL(ADL.BURDENABLE_RAW_COST,0) <> 0
2803: and APSAT.EXPENDITURE_TYPE = P_RECORD.EXPENDITURE_TYPE
2804: and ADL.AWARD_SET_ID = APSAT.AWARD_ID
2805: and G.LEDGER_ID = APSAT.SET_OF_BOOKS_ID
2806: and PA_CMT_UTILS.get_apdist_amt( APSAT.INVOICE_DISTRIBUTION_ID,
2807: APSAT.INVOICE_ID,
2808: nvl(apSAT.base_amount,apSAT.amount),
2809: 'N',
2810: 'GMS', NVL(G.SLA_LEDGER_CASH_BASIS_FLAG,'N') ) <> 0

Line 3014: select sum( pa_cmt_utils.get_apdist_amt(ap.invoice_distribution_id,

3010: and apSAT.invoice_distribution_id = P_RECORD.document_distribution_id ;
3011:
3012:
3013: cursor AP_ZERO_INVOICE is
3014: select sum( pa_cmt_utils.get_apdist_amt(ap.invoice_distribution_id,
3015: ap.invoice_id,
3016: nvl(ap.base_amount,ap.amount),
3017: 'N',
3018: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) ) sum_amount ,

Line 3030: and pa_cmt_utils.get_apdist_amt(ap.invoice_distribution_id,

3026: and adl.award_id = bc_pkt_rec.award_id
3027: and ap.expenditure_type = bc_pkt_rec.expenditure_type
3028: and ADL.award_set_id = AP.award_id
3029: and G.LEDGER_ID = AP.SET_OF_BOOKS_ID
3030: and pa_cmt_utils.get_apdist_amt(ap.invoice_distribution_id,
3031: ap.invoice_id,
3032: nvl(ap.base_amount,ap.amount),
3033: 'N',
3034: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) <> 0

Line 3040: select sum( pa_cmt_utils.get_apdist_amt(APSAT.invoice_distribution_id,

3036: and decode(ap.pa_addition_flag,'Z','Y', 'T','Y', 'E','Y', 'G', 'Y',NULL, 'N', ap.pa_addition_flag ) <> 'Y'
3037: -- Bug 2097676, Fixing GSCC error File.sql.9
3038: and ap.invoice_id = bc_pkt_rec.document_header_id
3039: union /* BUG 14216205 : Added the union for SAT */
3040: select sum( pa_cmt_utils.get_apdist_amt(APSAT.invoice_distribution_id,
3041: APSAT.invoice_id,
3042: nvl(APSAT.base_amount,APSAT.amount),
3043: 'N',
3044: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) ) sum_amount ,

Line 3056: and pa_cmt_utils.get_apdist_amt(APSAT.invoice_distribution_id,

3052: and adl.award_id = bc_pkt_rec.award_id
3053: and APSAT.expenditure_type = bc_pkt_rec.expenditure_type
3054: and ADL.award_set_id = APSAT.award_id
3055: and G.LEDGER_ID = APSAT.SET_OF_BOOKS_ID
3056: and pa_cmt_utils.get_apdist_amt(APSAT.invoice_distribution_id,
3057: APSAT.invoice_id,
3058: nvl(APSAT.base_amount,APSAT.amount),
3059: 'N',
3060: 'GMS',NVL(G.SLA_LEDGER_CASH_BASIS_FLAG,'N') ) <> 0

Line 3666: select sum( pa_cmt_utils.get_apdist_amt(ap.invoice_distribution_id,

3662: -- Cursor that checks for Net Zero AP
3663: cursor AP_ZERO_INVOICE (p_invoice_id in number,
3664: p_award_id in number,
3665: p_expenditure_type in varchar2) is
3666: select sum( pa_cmt_utils.get_apdist_amt(ap.invoice_distribution_id,
3667: ap.invoice_id,
3668: nvl(ap.base_amount,ap.amount),
3669: 'N',
3670: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) ) sum_amount

Line 3681: and pa_cmt_utils.get_apdist_amt(ap.invoice_distribution_id,

3677: and ap.expenditure_type = p_expenditure_type
3678: and ADL.award_set_id = AP.award_id
3679: and ap.invoice_id = p_invoice_id
3680: and G.LEDGER_ID = AP.SET_OF_BOOKS_ID
3681: and pa_cmt_utils.get_apdist_amt(ap.invoice_distribution_id,
3682: ap.invoice_id,
3683: nvl(ap.base_amount,ap.amount),
3684: 'N',
3685: 'GMS', nvl(g.sla_ledger_cash_basis_flag,'N') ) <> 0