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 AP_INVOICE_DISTRIBUTIONS

Line 379: ap_invoice_distributions D,

375: , adl.resource_list_member_id
376: , adl.bud_task_id
377: , adl.ind_compiled_set_id
378: from ap_invoices I,
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,

Line 440: ap_invoice_distributions D,

436: , adl.resource_list_member_id
437: , adl.bud_task_id
438: , adl.ind_compiled_set_id
439: from ap_invoices I,
440: ap_invoice_distributions D,
441: gms_award_distributions ADL,
442: gl_ledgers g
443: where i.invoice_id = d.invoice_id
444: and pa_cmt_utils.get_apdist_amt(d.invoice_distribution_id,

Line 1241: -- ap_invoice_distributions_all apd

1237: select adl.ind_compiled_set_id
1238: into l_compiled_set_id
1239: from gms_award_distributions adl
1240: -- R12 Funds Managment Uptake : Obsolete Ap/PO/REQ usage as its not required
1241: -- ap_invoice_distributions_all apd
1242: where adl.award_id = x_award_id
1243: and adl.task_id = x_task_id
1244: and adl.invoice_id = x_document_header_id
1245: and adl.invoice_distribution_id = x_document_distribution_id -- AP Lines change

Line 2496: FROM ap_invoice_distributions APD,

2492: apd.expenditure_organization_id,
2493: adl.resource_list_member_id,
2494: adl.bud_task_id,
2495: adl.ind_compiled_set_id
2496: FROM ap_invoice_distributions APD,
2497: gms_award_distributions ADL,
2498: gl_ledgers G
2499: where adl.invoice_distribution_id = APD.invoice_distribution_id
2500: and adl.adl_status = 'A'

Line 2629: from ap_invoice_distributions_all apd1,

2625: apd2.expenditure_organization_id,
2626: adl.resource_list_member_id,
2627: adl.bud_task_id,
2628: adl.ind_compiled_set_id
2629: from ap_invoice_distributions_all apd1,
2630: ap_invoice_distributions_all apd2,
2631: gms_award_distributions adl
2632: where apd1.invoice_distribution_id = bc_pkt_rec.document_distribution_id
2633: and apd2.invoice_distribution_id = apd1.prepay_distribution_id

Line 2630: ap_invoice_distributions_all apd2,

2626: adl.resource_list_member_id,
2627: adl.bud_task_id,
2628: adl.ind_compiled_set_id
2629: from ap_invoice_distributions_all apd1,
2630: ap_invoice_distributions_all apd2,
2631: gms_award_distributions adl
2632: where apd1.invoice_distribution_id = bc_pkt_rec.document_distribution_id
2633: and apd2.invoice_distribution_id = apd1.prepay_distribution_id
2634: and apd2.award_id = adl.award_set_id

Line 2647: l_prepay_type ap_invoice_distributions_all.line_type_lookup_code%TYPE ;

2643: l_sum_count NUMBER ;
2644: l_header_id NUMBER ;
2645: l_memo NUMBER ;
2646:
2647: l_prepay_type ap_invoice_distributions_all.line_type_lookup_code%TYPE ;
2648: l_prepay_dist_id NUMBER ;
2649: l_prepayment_brc number ;
2650: l_prepay_header_id NUMBER ;
2651: l_prepay_award_set_id NUMBER ;

Line 2653: l_prepay_exp_type ap_invoice_distributions.expenditure_type%TYPE ;

2649: l_prepayment_brc number ;
2650: l_prepay_header_id NUMBER ;
2651: l_prepay_award_set_id NUMBER ;
2652: l_prepay_award_id NUMBER ;
2653: l_prepay_exp_type ap_invoice_distributions.expenditure_type%TYPE ;
2654: l_prepay_project_id number ;
2655: l_prepay_task_id number ;
2656: l_prepay_ei_date date ;
2657: l_prepay_exp_org_id number ;

Line 2665: FROM ap_invoice_distributions AP,

2661:
2662:
2663: CURSOR C_GET_AWARD_SET_ID IS
2664: SELECT adl.award_set_id , adl.adl_line_num
2665: FROM ap_invoice_distributions AP,
2666: gms_award_distributions ADL
2667: where adl.invoice_distribution_id = AP.invoice_distribution_id
2668: and adl.adl_status = 'A'
2669: and adl.award_id = p_record.award_id

Line 2683: FROM ap_invoice_distributions AP,

2679: 'N',
2680: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) ) sum_amount ,
2681: sum(nvl(adl.burdenable_raw_cost,0)) sum_burden,
2682: count(*) sum_count
2683: FROM ap_invoice_distributions AP,
2684: gms_award_distributions ADL,
2685: gl_ledgers G
2686: where adl.invoice_distribution_id = AP.invoice_distribution_id
2687: and adl.adl_status = 'A'

Line 3307: FROM ap_invoice_distributions AP,

3303: ap.invoice_id,
3304: nvl(ap.base_amount,ap.amount),
3305: 'N',
3306: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) ) sum_amount
3307: FROM ap_invoice_distributions AP,
3308: gms_award_distributions ADL,
3309: GL_LEDGERS G
3310: where adl.invoice_distribution_id = AP.invoice_distribution_id
3311: and adl.adl_status = 'A'

Line 4220: PROCEDURE CALC_prepayment_burden( X_AP_REC ap_invoice_distributions_all%ROWTYPE , X_adl_rec gms_award_distributions%ROWTYPE ) is

4216: BEGIN
4217: null; -- All code remove as this will be taken care by Interface FC
4218: END PPAY_LOG_POSTING ;
4219:
4220: PROCEDURE CALC_prepayment_burden( X_AP_REC ap_invoice_distributions_all%ROWTYPE , X_adl_rec gms_award_distributions%ROWTYPE ) is
4221: BEGIN
4222: null; -- All code remove as this will be taken care by Interface FC
4223: END CALC_prepayment_burden ;
4224:

Line 4399: ap_invoice_distributions_all apd

4395: --
4396: select adl.ind_compiled_set_id
4397: into x_ind_compiled_set_id
4398: from gms_award_distributions adl,
4399: ap_invoice_distributions_all apd
4400: where apd.distribution_line_number = x_distribution_line_number
4401: and apd.invoice_distribution_id = x_distribution_id -- AP Lines change
4402: and apd.award_id = adl.award_set_id
4403: and adl.adl_line_num = 1 ;

Line 4468: ap_invoice_distributions_all apd

4464: --
4465: select adl.burdenable_raw_cost
4466: into x_burdenable_raw_cost
4467: from gms_award_distributions adl,
4468: ap_invoice_distributions_all apd
4469: where apd.distribution_line_number = x_distribution_line_number
4470: and apd.invoice_distribution_id = x_distribution_id -- AP Lines change
4471: and apd.award_id = adl.award_set_id
4472: and adl.adl_line_num = 1 ;