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.PA_TRX_IMPORT dependencies on PA_BC_COMMITMENTS_ALL

Line 12193: From Pa_Bc_Commitments_all bcc

12189: ,bcc.parent_bc_packet_id
12190: ,bcc.encumbrance_type_id
12191: ,bcc.document_header_id_2
12192: ,bcc.document_distribution_type
12193: From Pa_Bc_Commitments_all bcc
12194: Where bcc.Document_Header_Id = p_sys_ref2
12195: and bcc.Document_Distribution_Id =p_sys_ref5
12196: --PA-J Receipt accrual changes
12197: and bcc.document_type = 'AP'

Line 13067: From Pa_Bc_Commitments_all bcc

13063: ,bcc.Org_Id
13064: ,bcc.Pa_Date
13065: ,bcc.bc_packet_id
13066: ,bcc.packet_id
13067: From Pa_Bc_Commitments_all bcc
13068: Where bcc.Document_Header_Id = p_sys_ref2
13069: and bcc.Document_Distribution_Id = p_sys_ref5
13070: and bcc.Parent_Bc_Packet_Id is NULL
13071: --PA-J Receipt accrual changes

Line 13354: From Pa_Bc_Commitments_all bcc

13350: ,p_txn_interface_id --REL12
13351: ,bcc.encumbrance_type_id
13352: ,bcc.document_header_id_2
13353: ,bcc.document_distribution_type
13354: From Pa_Bc_Commitments_all bcc
13355: Where bcc.Document_Header_Id = p_sys_ref2 -- Added for using index
13356: and bcc.Document_Distribution_Id = p_sys_ref5
13357: and bcc.packet_id = g_packet_id_tbl(i)
13358: and bcc.document_type = 'AP' ;

Line 13955: From Pa_Bc_Commitments_all bcc,

13951: ,bcc.Pa_Date
13952: ,bcc.bc_packet_id
13953: ,bcc.packet_id
13954: ,bcc.bc_commitment_id
13955: From Pa_Bc_Commitments_all bcc,
13956: po_distributions pod
13957: -- R12 Funds management Uptake : For fixing performance issues removing the code for CC which is obsolete for R12
13958: -- Modifying code to use Index on document_header_id and document_distribution_id of bc commitments
13959: where bcc.document_header_id = pod.po_header_id

Line 14257: From Pa_Bc_Commitments_all bcc

14253: ,p_txn_interface_id --REL12
14254: ,bcc.encumbrance_type_id
14255: ,bcc.document_header_id_2
14256: ,bcc.document_distribution_type
14257: From Pa_Bc_Commitments_all bcc
14258: Where bcc.bc_commitment_id in (SELECT bcc1.bc_commitment_id
14259: FROM PA_BC_COMMITMENTS_ALL bcc1
14260: WHERE bcc1.document_header_id = p_sys_ref2
14261: AND bcc1.document_distribution_id = p_sys_ref3

Line 14259: FROM PA_BC_COMMITMENTS_ALL bcc1

14255: ,bcc.document_header_id_2
14256: ,bcc.document_distribution_type
14257: From Pa_Bc_Commitments_all bcc
14258: Where bcc.bc_commitment_id in (SELECT bcc1.bc_commitment_id
14259: FROM PA_BC_COMMITMENTS_ALL bcc1
14260: WHERE bcc1.document_header_id = p_sys_ref2
14261: AND bcc1.document_distribution_id = p_sys_ref3
14262: AND bcc1.parent_bc_packet_id = g_bc_packet_id_tbl(i)
14263: UNIOn ALL