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_FUNDS_CONTROL_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 446: from ap_invoice_distributions_all a,

442: where packet_id = p_packet_id
443: and substr(result_code,1,1) = 'P'
444: and (document_header_id,document_distribution_id) in
445: ( select distinct b.invoice_id,b.invoice_distribution_id
446: from ap_invoice_distributions_all a,
447: ap_invoice_distributions_all b
448: where (a.invoice_id,a.invoice_distribution_id) in
449: (select document_header_id,
450: document_distribution_id

Line 447: ap_invoice_distributions_all b

443: and substr(result_code,1,1) = 'P'
444: and (document_header_id,document_distribution_id) in
445: ( select distinct b.invoice_id,b.invoice_distribution_id
446: from ap_invoice_distributions_all a,
447: ap_invoice_distributions_all b
448: where (a.invoice_id,a.invoice_distribution_id) in
449: (select document_header_id,
450: document_distribution_id
451: from gms_bc_packets gbc

Line 494: ap_invoice_distributions_all apid

490: and bp.packet_id = p_packet_id
491: and bp.status_code = 'P'
492: and bp.document_distribution_id in ( select distinct apid.po_distribution_id
493: from gms_bc_packets bp1,
494: ap_invoice_distributions_all apid
495: where bp1.packet_id = p_packet_id
496: and bp1.document_type = 'AP'
497: and bp1.document_distribution_id = apid.invoice_distribution_id
498: and substr(bp1.result_code,1,1) = 'F'

Line 1310: FROM ap_invoice_distributions_all ap,

1306: SELECT DISTINCT adl.award_set_id,
1307: adl.document_type, -- Bug 2433889
1308: adl.invoice_id, -- Bug 2433889
1309: adl.invoice_distribution_id -- Bug 2433889
1310: FROM ap_invoice_distributions_all ap,
1311: gms_award_distributions adl
1312: WHERE ap.invoice_distribution_id = p_inv_dist_id
1313: AND ap.award_id IS NOT NULL
1314: AND ap.award_id = adl.award_set_id

Line 1502: ap_invoice_distributions_all apd

1498: where adl.document_type = 'AP'
1499: and adl.adl_status = 'I'
1500: and adl.award_set_id in ( select adl2.award_set_id
1501: from gms_award_distributions adl2,
1502: ap_invoice_distributions_all apd
1503: where apd.invoice_id = g_doc_header_id_tab(i)
1504: AND apd.invoice_distribution_id = g_doc_dist_id_tab(i)
1505: and apd.award_id is not null
1506: and adl2.award_set_id = apd.award_id

Line 1612: UPDATE ap_invoice_distributions_all

1608: x_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;
1609:
1610: gms_awards_dist_pkg.create_adls (x_rec);
1611:
1612: UPDATE ap_invoice_distributions_all
1613: SET award_id = x_rec.award_set_id
1614: WHERE invoice_id = g_doc_header_id_tab(i)
1615: AND invoice_distribution_id = g_doc_dist_id_tab(i);
1616:

Line 2257: ap_invoice_distributions_all apd,

2253: /* Added for Bug 5645290 */
2254: decode (apd.prepay_distribution_id ,NULL,line_type_lookup_code,'PREPAY')
2255: /* Bug 5645290 - End */
2256: FROM psa_bc_xla_events_gt xlaevt,
2257: ap_invoice_distributions_all apd,
2258: gms_project_types gpt,
2259: pa_projects_all pp,
2260: ap_invoices_all apinv
2261: WHERE apd.bc_event_id = xlaevt.event_id

Line 2358: from ap_invoice_distributions_all apd

2354: AND (p_mode ='C' OR (apext.aid_line_type_lookup_code <> 'PREPAY' AND p_mode <>'C')) */
2355: /* Adding for Bug 5645290*/
2356: AND exists (
2357: select 1
2358: from ap_invoice_distributions_all apd
2359: where apd.invoice_distribution_id = apext.aid_invoice_dist_id
2360: and ((apd.prepay_distribution_id is NULL AND p_mode <>'C') OR p_mode ='C' ))
2361: /* Bug 5645290 - End */
2362: AND p_stdinvoice_exists = 'Y'

Line 2405: AP_INVOICE_DISTRIBUTIONS_ALL AID

2401: -- Last col. will be used in Synch_gms_gl_packets ...
2402: FROM AP_PREPAY_HISTORY_ALL APPH,
2403: AP_PREPAY_APP_DISTS APAD,
2404: AP_INVOICE_LINES_ALL AIL,
2405: AP_INVOICE_DISTRIBUTIONS_ALL AID
2406: WHERE AID.bc_event_id = APPH.bc_Event_id
2407: AND APPH.prepay_history_id = APAD.prepay_history_id
2408: AND AID.invoice_line_number = AIL.line_number
2409: AND AID.invoice_id = AIL.invoice_id

Line 2507: FROM ap_invoice_distributions_all apd,

2503: AND apd.parent_reversal_id IS NOT NULL
2504: AND adl1.award_set_id = ap1.award_id
2505: AND adl1.adl_line_num =1 ) burdenable_raw_cost ,
2506: apd.parent_reversal_id parent_reversal_id -- Bug 5369296
2507: FROM ap_invoice_distributions_all apd,
2508: ap_invoices_all api,
2509: gms_award_distributions adl,
2510: pa_expenditure_types et
2511: WHERE apd.invoice_distribution_id = p_ap_dist_id

Line 7965: ap_invoice_distributions_all ap,

7961: pod.task_id task_id,
7962: adl.award_id award_id
7963: FROM gms_bc_packets pkt,
7964: gl_bc_packets gl,
7965: ap_invoice_distributions_all ap,
7966: po_distributions_all pod,
7967: gms_award_distributions adl
7968: WHERE pkt.packet_id = x_packet_id
7969: AND pkt.document_type = 'AP'

Line 8056: ap_invoice_distributions_all apd

8052: And document_type = 'AP'
8053: And bc_packet_id in
8054: ( select a.bc_packet_id
8055: from gms_bc_packets a,
8056: ap_invoice_distributions_all apd
8057: where a.packet_id = x_packet_id
8058: and a.document_type = 'AP'
8059: and a.document_header_id = apd.invoice_id
8060: and a.document_distribution_id = apd.distribution_line_number