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 459: ap_invoice_distributions D,

455: , adl.resource_list_member_id
456: , adl.bud_task_id
457: , adl.ind_compiled_set_id
458: from ap_invoices I,
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,

Line 578: ap_invoice_distributions D,

574: , adl.resource_list_member_id
575: , adl.bud_task_id
576: , adl.ind_compiled_set_id
577: from ap_invoices I,
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,

Line 652: ap_invoice_distributions D,

648: , adl.resource_list_member_id
649: , adl.bud_task_id
650: , adl.ind_compiled_set_id
651: from ap_invoices I,
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,

Line 1508: -- ap_invoice_distributions_all apd

1504: select adl.ind_compiled_set_id
1505: into l_compiled_set_id
1506: from gms_award_distributions adl
1507: -- R12 Funds Managment Uptake : Obsolete Ap/PO/REQ usage as its not required
1508: -- ap_invoice_distributions_all apd
1509: where adl.award_id = x_award_id
1510: and adl.task_id = x_task_id
1511: and adl.invoice_id = x_document_header_id
1512: and adl.invoice_distribution_id = x_document_distribution_id -- AP Lines change

Line 2763: FROM ap_invoice_distributions APD,

2759: apd.expenditure_organization_id,
2760: adl.resource_list_member_id,
2761: adl.bud_task_id,
2762: adl.ind_compiled_set_id
2763: FROM ap_invoice_distributions APD,
2764: gms_award_distributions ADL,
2765: gl_ledgers G
2766: where adl.invoice_distribution_id = APD.invoice_distribution_id
2767: and adl.adl_status = 'A'

Line 2929: from ap_invoice_distributions_all apd1,

2925: apd2.expenditure_organization_id,
2926: adl.resource_list_member_id,
2927: adl.bud_task_id,
2928: adl.ind_compiled_set_id
2929: from ap_invoice_distributions_all apd1,
2930: ap_invoice_distributions_all apd2,
2931: gms_award_distributions adl
2932: where apd1.invoice_distribution_id = bc_pkt_rec.document_distribution_id
2933: and apd2.invoice_distribution_id = apd1.prepay_distribution_id

Line 2930: ap_invoice_distributions_all apd2,

2926: adl.resource_list_member_id,
2927: adl.bud_task_id,
2928: adl.ind_compiled_set_id
2929: from ap_invoice_distributions_all apd1,
2930: ap_invoice_distributions_all apd2,
2931: gms_award_distributions adl
2932: where apd1.invoice_distribution_id = bc_pkt_rec.document_distribution_id
2933: and apd2.invoice_distribution_id = apd1.prepay_distribution_id
2934: and apd2.award_id = adl.award_set_id

Line 2973: l_prepay_type ap_invoice_distributions_all.line_type_lookup_code%TYPE ;

2969: l_sum_count NUMBER ;
2970: l_header_id NUMBER ;
2971: l_memo NUMBER ;
2972:
2973: l_prepay_type ap_invoice_distributions_all.line_type_lookup_code%TYPE ;
2974: l_prepay_dist_id NUMBER ;
2975: l_prepayment_brc number ;
2976: l_prepay_header_id NUMBER ;
2977: l_prepay_award_set_id NUMBER ;

Line 2979: l_prepay_exp_type ap_invoice_distributions.expenditure_type%TYPE ;

2975: l_prepayment_brc number ;
2976: l_prepay_header_id NUMBER ;
2977: l_prepay_award_set_id NUMBER ;
2978: l_prepay_award_id NUMBER ;
2979: l_prepay_exp_type ap_invoice_distributions.expenditure_type%TYPE ;
2980: l_prepay_project_id number ;
2981: l_prepay_task_id number ;
2982: l_prepay_ei_date date ;
2983: l_prepay_exp_org_id number ;

Line 2991: FROM ap_invoice_distributions AP,

2987:
2988:
2989: CURSOR C_GET_AWARD_SET_ID IS
2990: SELECT adl.award_set_id , adl.adl_line_num
2991: FROM ap_invoice_distributions AP,
2992: gms_award_distributions ADL
2993: where adl.invoice_distribution_id = AP.invoice_distribution_id
2994: and adl.adl_status = 'A'
2995: and adl.award_id = p_record.award_id

Line 3021: FROM ap_invoice_distributions AP,

3017: 'N',
3018: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) ) sum_amount ,
3019: sum(nvl(adl.burdenable_raw_cost,0)) sum_burden,
3020: count(*) sum_count
3021: FROM ap_invoice_distributions AP,
3022: gms_award_distributions ADL,
3023: gl_ledgers G
3024: where adl.invoice_distribution_id = AP.invoice_distribution_id
3025: and adl.adl_status = 'A'

Line 3671: FROM ap_invoice_distributions AP,

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
3671: FROM ap_invoice_distributions AP,
3672: gms_award_distributions ADL,
3673: GL_LEDGERS G
3674: where adl.invoice_distribution_id = AP.invoice_distribution_id
3675: and adl.adl_status = 'A'

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

4598: BEGIN
4599: null; -- All code remove as this will be taken care by Interface FC
4600: END PPAY_LOG_POSTING ;
4601:
4602: PROCEDURE CALC_prepayment_burden( X_AP_REC ap_invoice_distributions_all%ROWTYPE , X_adl_rec gms_award_distributions%ROWTYPE ) is
4603: BEGIN
4604: null; -- All code remove as this will be taken care by Interface FC
4605: END CALC_prepayment_burden ;
4606:

Line 4790: ap_invoice_distributions_all apd

4786: /* BUG 14216205 : Commented the below code : Starts */
4787: /*select adl.ind_compiled_set_id
4788: into x_ind_compiled_set_id
4789: from gms_award_distributions adl,
4790: ap_invoice_distributions_all apd
4791: where apd.distribution_line_number = x_distribution_line_number
4792: and apd.invoice_distribution_id = x_distribution_id -- AP Lines change
4793: and apd.award_id = adl.award_set_id
4794: and adl.adl_line_num = 1 ;*/

Line 4802: ap_invoice_distributions_all apd

4798: BEGIN
4799: select adl.ind_compiled_set_id
4800: into x_ind_compiled_set_id
4801: from gms_award_distributions adl,
4802: ap_invoice_distributions_all apd
4803: where apd.distribution_line_number = x_distribution_line_number
4804: and apd.invoice_distribution_id = x_distribution_id -- AP Lines change
4805: and apd.award_id = adl.award_set_id
4806: and ADL.ADL_LINE_NUM = 1 ;

Line 4890: ap_invoice_distributions_all apd

4886: /* BUG 14216205 : Commented the below code : Starts */
4887: /*select adl.burdenable_raw_cost
4888: into x_burdenable_raw_cost
4889: from gms_award_distributions adl,
4890: ap_invoice_distributions_all apd
4891: where apd.distribution_line_number = x_distribution_line_number
4892: and apd.invoice_distribution_id = x_distribution_id -- AP Lines change
4893: and apd.award_id = adl.award_set_id
4894: and adl.adl_line_num = 1 ;*/

Line 4902: ap_invoice_distributions_all apd

4898: BEGIN
4899: select adl.burdenable_raw_cost
4900: into x_burdenable_raw_cost
4901: from gms_award_distributions adl,
4902: ap_invoice_distributions_all apd
4903: where apd.distribution_line_number = x_distribution_line_number
4904: and apd.invoice_distribution_id = x_distribution_id -- AP Lines change
4905: and apd.award_id = adl.award_set_id
4906: and adl.adl_line_num = 1 ;