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 PSA_BC_XLA_EVENTS_GT

Line 2284: psa_bc_xla_events_gt xlaevt,

2280: NULL, -- burdenable_raw_cost
2281: pobc.reference6, -- For GMSIP
2282: pobc.reference13 --Vendor id for GMSIP transactions
2283: FROM po_bc_distributions pobc ,
2284: psa_bc_xla_events_gt xlaevt,
2285: pa_expenditure_types et,
2286: gms_project_types gpt,
2287: pa_projects_all pp
2288: WHERE pobc.ae_event_id = xlaevt.event_id

Line 2303: FROM psa_bc_xla_events_gt xlaevt,

2299: apd.line_type_lookup_code */
2300: /* Added for Bug 5645290 */
2301: decode (apd.prepay_distribution_id ,NULL,line_type_lookup_code,'PREPAY')
2302: /* Bug 5645290 - End */
2303: FROM psa_bc_xla_events_gt xlaevt,
2304: ap_invoice_distributions_all apd,
2305: gms_project_types gpt,
2306: pa_projects_all pp,
2307: ap_invoices_all apinv

Line 2327: from PSA_BC_XLA_EVENTS_GT XLAEVT,

2323: apd.line_type_lookup_code <> 'PREPAY' )
2324: UNION /* BUG 14216205 : Added the union for SAT */
2325: SELECT apsat.invoice_distribution_id,
2326: DECODE (apsat.prepay_distribution_id ,NULL,line_type_lookup_code,'PREPAY')
2327: from PSA_BC_XLA_EVENTS_GT XLAEVT,
2328: AP_SELF_ASSESSED_TAX_DIST_ALL apsat,
2329: gms_project_types gpt,
2330: pa_projects_all pp,
2331: ap_invoices_all apinv

Line 2456: PSA_BC_XLA_EVENTS_GT PBXEG

2452: AND AID.ORG_ID = FSP.ORG_ID
2453: AND aid.set_of_books_id = asp.set_of_books_id
2454: AND aid.org_id = asp.org_id
2455: ) apext, -- Bug 5500126
2456: PSA_BC_XLA_EVENTS_GT PBXEG
2457: WHERE apext.aid_invoice_dist_id IN (select Column_Value from Table(g_ap_inv_dist_id))
2458: /* AND apext.event_id in ( SELECT event_id FROM psa_bc_xla_events_gt) */
2459: AND apext.event_id = PBXEG.EVENT_ID
2460: -- Bug 5238282 : Prepayment application will be treated as standard invoice line for check funds

Line 2458: /* AND apext.event_id in ( SELECT event_id FROM psa_bc_xla_events_gt) */

2454: AND aid.org_id = asp.org_id
2455: ) apext, -- Bug 5500126
2456: PSA_BC_XLA_EVENTS_GT PBXEG
2457: WHERE apext.aid_invoice_dist_id IN (select Column_Value from Table(g_ap_inv_dist_id))
2458: /* AND apext.event_id in ( SELECT event_id FROM psa_bc_xla_events_gt) */
2459: AND apext.event_id = PBXEG.EVENT_ID
2460: -- Bug 5238282 : Prepayment application will be treated as standard invoice line for check funds
2461: -- as there will be no data in ap_prepay_app_dists table.This table is populated during invoice
2462: -- validation.

Line 2563: PSA_BC_XLA_EVENTS_GT PBXEG

2559: WHERE nvl(ASAT.posted_flag,'N') <> 'Y'
2560: AND ASAT.po_distribution_id = POD.po_distribution_id(+)
2561: AND ASAT.po_distribution_id = IGC.po_distribution_id(+)
2562: ) apext, -- Bug 5500126
2563: PSA_BC_XLA_EVENTS_GT PBXEG
2564: WHERE apext.aid_invoice_dist_id IN (select Column_Value from Table(g_ap_inv_dist_id))
2565: /* AND apext.event_id in ( SELECT event_id FROM psa_bc_xla_events_gt) */
2566: AND apext.event_id = PBXEG.EVENT_ID
2567: -- Bug 5238282 : Prepayment application will be treated as standard invoice line for check funds

Line 2565: /* AND apext.event_id in ( SELECT event_id FROM psa_bc_xla_events_gt) */

2561: AND ASAT.po_distribution_id = IGC.po_distribution_id(+)
2562: ) apext, -- Bug 5500126
2563: PSA_BC_XLA_EVENTS_GT PBXEG
2564: WHERE apext.aid_invoice_dist_id IN (select Column_Value from Table(g_ap_inv_dist_id))
2565: /* AND apext.event_id in ( SELECT event_id FROM psa_bc_xla_events_gt) */
2566: AND apext.event_id = PBXEG.EVENT_ID
2567: -- Bug 5238282 : Prepayment application will be treated as standard invoice line for check funds
2568: -- as there will be no data in ap_prepay_app_dists table.This table is populated during invoice
2569: -- validation.

Line 2587: SELECT /+ leading(PSA_BC_XLA_EVENTS_GT) cardinality(PSA_BC_XLA_EVENTS_GT,1) / /* 9694907 */

2583: ) /* BUG 14216205 : Added the following Code for SAT : Ends */
2584: /* Bug 5645290 - End */
2585: AND p_stdinvoice_exists = 'Y'
2586: UNION ALL
2587: SELECT /*+ leading(PSA_BC_XLA_EVENTS_GT) cardinality(PSA_BC_XLA_EVENTS_GT,1) */ /* 9694907 */
2588: 'Payables' je_source_name,
2589: 'Purchase Invoices' je_category_name,
2590: 'E' actual_flag,
2591: AID.project_id project_id,

Line 2627: PSA_BC_XLA_EVENTS_GT PBXEG,

2623: NULL inv_dist_reference_2,
2624: APAD.prepay_app_dist_id ap_prepay_app_dist_id
2625: -- Last col. will be used in Synch_gms_gl_packets ...
2626: FROM AP_PREPAY_HISTORY_ALL APPH,
2627: PSA_BC_XLA_EVENTS_GT PBXEG,
2628: AP_PREPAY_APP_DISTS APAD,
2629: AP_INVOICE_LINES_ALL AIL,
2630: AP_INVOICE_DISTRIBUTIONS_ALL AID
2631: WHERE AID.bc_event_id = APPH.bc_Event_id

Line 2636: /* and APPH.bc_Event_id IN ( SELECT event_id FROM psa_bc_xla_events_gt) */

2632: AND APPH.prepay_history_id = APAD.prepay_history_id
2633: AND AID.invoice_line_number = AIL.line_number
2634: AND AID.invoice_id = AIL.invoice_id
2635: AND AID.line_type_lookup_code IN ( 'PREPAY' ,'NONREC_TAX' ) --Bug 5490378
2636: /* and APPH.bc_Event_id IN ( SELECT event_id FROM psa_bc_xla_events_gt) */
2637: AND APPH.bc_Event_id = PBXEG.event_id
2638: and AID.invoice_distribution_id IN (select Column_Value from Table(g_ap_inv_dist_id))
2639: AND p_prepay_exists = 'Y'
2640: and aid.invoice_distribution_id = apad.prepay_app_distribution_id

Line 9205: FROM PSA_BC_XLA_EVENTS_GT

9201: result_code = 'F22'
9202: WHERE status_code in ('I','A','S')
9203: AND source_event_id IN
9204: (SELECT event_id
9205: FROM PSA_BC_XLA_EVENTS_GT
9206: WHERE upper(result_code) in ('XLA_ERROR','FATAL'));
9207:
9208: END TIEBACK_FAILED_ACCT_STATUS;
9209: