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.PSA_BC_XML_REPORT_PUB dependencies on PSA_BC_REPORT_V

Line 85: -- Build the query to get the data from PSA_BC_REPORT_V

81: l_para_rec.bc_funds_check_order_by := p_order_by;
82: l_para_rec.application_id := l_application_id;
83:
84:
85: -- Build the query to get the data from PSA_BC_REPORT_V
86: psa_utils.debug_other_string(g_state_level,l_api_name,'Call build_report_query Procedure' );
87: psa_utils.debug_other_string(g_state_level,l_api_name,'l_return_status: ' || l_return_status );
88:
89: build_report_query(x_return_status => l_return_status,

Line 214: -- Build the query to get the data from PSA_BC_REPORT_V

210: l_para_rec.application_id := l_application_id;
211: l_para_rec.packet_event_flag := p_packet_event_flag;
212: l_para_rec.sequence_id := p_sequence_id;
213:
214: -- Build the query to get the data from PSA_BC_REPORT_V
215: psa_utils.debug_other_string(g_state_level,l_api_name,'Call build_report_query Procedure');
216:
217: build_report_query(x_return_status => l_return_status,
218: x_source => 'FORM',

Line 270: -- Build the SQL Query from PSA_BC_REPORT_V view

266: -------------------------------------------------------------------------------
267: -- PROCEDURE build_report_query
268: -- Start of Comments
269: -- Purpose:
270: -- Build the SQL Query from PSA_BC_REPORT_V view
271: -- The query is build based on the report paramaters
272: -- End of Comments
273: -------------------------------------------------------------------------------
274:

Line 910: FROM PSA_BC_REPORT_V PBRV,

906: 'O' ERROR_SOURCE,
907: PBRV.CURRENT_FUNDS_AVAILABLE CURRENT_FUNDS_AVAILABLE,
908: NULL DOCUMENT_STATUS
909: BULK COLLECT INTO l_dump
910: FROM PSA_BC_REPORT_V PBRV,
911: GL_JE_HEADERS JH,
912: PSA_BC_REPORT_EVENTS_GT PBRE
913: WHERE PBRV.je_header_id = JH.je_header_id(+) AND
914: PBRV.ledger_id = p_para_rec.ledger_id AND

Line 1045: FROM PSA_BC_REPORT_V PBRV,

1041: 'O' ERROR_SOURCE,
1042: PBRV.CURRENT_FUNDS_AVAILABLE CURRENT_FUNDS_AVAILABLE,
1043: NULL DOCUMENT_STATUS
1044: BULK COLLECT INTO l_dump
1045: FROM PSA_BC_REPORT_V PBRV,
1046: AP_INVOICE_DISTRIBUTIONS AID,
1047: AP_BATCHES APB,
1048: XLA_DISTRIBUTION_LINKS XDL,
1049: AP_INVOICES AI,

Line 1203: FROM PSA_BC_REPORT_V PBRV,

1199: 'O' ERROR_SOURCE,
1200: PBRV.CURRENT_FUNDS_AVAILABLE CURRENT_FUNDS_AVAILABLE,
1201: NULL DOCUMENT_STATUS
1202: BULK COLLECT INTO l_dump
1203: FROM PSA_BC_REPORT_V PBRV,
1204: AP_INVOICE_DISTRIBUTIONS AID,
1205: AP_PREPAY_APP_DISTS APD,
1206: AP_BATCHES APB,
1207: XLA_DISTRIBUTION_LINKS XDL,

Line 1373: FROM PSA_BC_REPORT_V PBRV,

1369: 'O' ERROR_SOURCE,
1370: PBRV.CURRENT_FUNDS_AVAILABLE CURRENT_FUNDS_AVAILABLE,
1371: NULL DOCUMENT_STATUS
1372: BULK COLLECT INTO l_dump
1373: FROM PSA_BC_REPORT_V PBRV,
1374: PO_BC_DISTRIBUTIONS PBD,
1375: XLA_DISTRIBUTION_LINKS XDL,
1376: PO_VENDORS PV,
1377: PO_VENDOR_SITES PVS,

Line 1533: FROM PSA_BC_REPORT_V PBRV,

1529: 'O' ERROR_SOURCE,
1530: PBRV.CURRENT_FUNDS_AVAILABLE CURRENT_FUNDS_AVAILABLE,
1531: NULL DOCUMENT_STATUS
1532: BULK COLLECT INTO l_dump
1533: FROM PSA_BC_REPORT_V PBRV,
1534: PO_BC_DISTRIBUTIONS PBD,
1535: XLA_DISTRIBUTION_LINKS XDL,
1536: PO_VENDORS PV,
1537: PO_VENDOR_SITES PVS,

Line 1697: FROM PSA_BC_REPORT_V PBRV,

1693: 'O' ERROR_SOURCE,
1694: PBRV.CURRENT_FUNDS_AVAILABLE CURRENT_FUNDS_AVAILABLE,
1695: NULL DOCUMENT_STATUS
1696: BULK COLLECT INTO l_dump
1697: FROM PSA_BC_REPORT_V PBRV,
1698: PO_BC_DISTRIBUTIONS PBD,
1699: XLA_DISTRIBUTION_LINKS XDL,
1700: PO_VENDORS PV,
1701: PO_VENDOR_SITES PVS,

Line 1991: FROM PSA_BC_REPORT_V PBRV,

1987: 'O' ERROR_SOURCE,
1988: PBRV.CURRENT_FUNDS_AVAILABLE,
1989: NULL DOCUMENT_STATUS
1990: BULK COLLECT INTO l_dump
1991: FROM PSA_BC_REPORT_V PBRV,
1992: XLA_DISTRIBUTION_LINKS XLADIST,
1993: FV_BE_TRX_HDRS BE,
1994: FV_BE_TRX_DTLS BET,
1995: FV_BE_RPR_TRANSACTIONS RPR,

Line 2141: FROM PSA_BC_REPORT_V PBRV,

2137: 'O' ERROR_SOURCE,
2138: PBRV.CURRENT_FUNDS_AVAILABLE,
2139: NULL DOCUMENT_STATUS
2140: BULK COLLECT INTO l_dump
2141: FROM PSA_BC_REPORT_V PBRV,
2142: PSA_BC_REPORT_EVENTS_GT PBRE
2143: WHERE PBRV.ledger_id = p_para_rec.ledger_id AND
2144: PBRV.application_id = p_para_rec.application_id AND
2145: PBRV.packet_id = PBRE.packet_id; -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause

Line 2267: FROM PSA_BC_REPORT_V PBRV,

2263: 'O' ERROR_SOURCE,
2264: PBRV.CURRENT_FUNDS_AVAILABLE,
2265: NULL DOCUMENT_STATUS
2266: BULK COLLECT INTO l_dump
2267: FROM PSA_BC_REPORT_V PBRV,
2268: PSA_BC_REPORT_EVENTS_GT PBRE
2269: WHERE PBRV.ledger_id = p_para_rec.ledger_id AND
2270: PBRV.application_id = p_para_rec.application_id AND
2271: PBRV.packet_id = PBRE.packet_id;

Line 2431: FROM PSA_BC_REPORT_V PBRV,

2427: 'O' ERROR_SOURCE,
2428: PBRV.CURRENT_FUNDS_AVAILABLE CURRENT_FUNDS_AVAILABLE,
2429: NULL DOCUMENT_STATUS
2430: BULK COLLECT INTO l_dump
2431: FROM PSA_BC_REPORT_V PBRV,
2432: PSA_BC_REPORT_EVENTS_GT PBRE
2433: WHERE PBRV.packet_id = PBRE.packet_id
2434: and template_id is NULL; -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause
2435:

Line 2554: FROM PSA_BC_REPORT_V PBRV,

2550: 'O' ERROR_SOURCE,
2551: PBRV.CURRENT_FUNDS_AVAILABLE CURRENT_FUNDS_AVAILABLE,
2552: NULL DOCUMENT_STATUS
2553: BULK COLLECT INTO l_dump
2554: FROM PSA_BC_REPORT_V PBRV,
2555: XLA_AE_HEADERS XAH,
2556: XLA_DISTRIBUTION_LINKS XDL,
2557: PSA_BC_REPORT_EVENTS_GT PBRE
2558: WHERE PBRV.application_id = XDL.application_id AND

Line 2729: PSA_BC_REPORT_V PBRV

2725: GL_BUDGETS B,
2726: GL_BUDGET_VERSIONS BV,
2727: GL_SUMMARY_BC_OPTIONS SB,
2728: GL_PERIOD_STATUSES PS2,
2729: PSA_BC_REPORT_V PBRV
2730: WHERE pbrg.ccid IS NOT NULL
2731: AND ah.ledger_id = p_para_rec.ledger_id
2732: AND ah.detail_code_combination_id = PBRG.CCID
2733: AND ps2.ledger_id = p_para_rec.ledger_id