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 13112: From Pa_Bc_Commitments_all bcc

13108: ,bcc.parent_bc_packet_id
13109: ,bcc.encumbrance_type_id
13110: ,bcc.document_header_id_2
13111: ,bcc.document_distribution_type
13112: From Pa_Bc_Commitments_all bcc
13113: Where bcc.Document_Header_Id = p_sys_ref2
13114: and bcc.Document_Distribution_Id =p_sys_ref5
13115: --PA-J Receipt accrual changes
13116: and bcc.document_type = 'AP'

Line 14016: From Pa_Bc_Commitments_all bcc

14012: ,bcc.Org_Id
14013: ,bcc.Pa_Date
14014: ,bcc.bc_packet_id
14015: ,bcc.packet_id
14016: From Pa_Bc_Commitments_all bcc
14017: Where bcc.Document_Header_Id = p_sys_ref2
14018: and bcc.Document_Distribution_Id = p_sys_ref5
14019: and bcc.Parent_Bc_Packet_Id is NULL
14020: --PA-J Receipt accrual changes

Line 14308: From Pa_Bc_Commitments_all bcc

14304: ,p_txn_interface_id --REL12
14305: ,bcc.encumbrance_type_id
14306: ,bcc.document_header_id_2
14307: ,bcc.document_distribution_type
14308: From Pa_Bc_Commitments_all bcc
14309: Where bcc.Document_Header_Id = p_sys_ref2 -- Added for using index
14310: and bcc.Document_Distribution_Id = p_sys_ref5
14311: and bcc.packet_id = g_packet_id_tbl(i)
14312: and bcc.document_type = 'AP' ;

Line 14922: From Pa_Bc_Commitments_all bcc,

14918: ,bcc.bc_packet_id
14919: ,bcc.packet_id
14920: ,bcc.bc_commitment_id
14921: ,bcc.vendor_id
14922: From Pa_Bc_Commitments_all bcc,
14923: po_distributions pod
14924: -- R12 Funds management Uptake : For fixing performance issues removing the code for CC which is obsolete for R12
14925: -- Modifying code to use Index on document_header_id and document_distribution_id of bc commitments
14926: where bcc.document_header_id = pod.po_header_id

Line 15235: From Pa_Bc_Commitments_all bcc

15231: ,p_txn_interface_id --REL12
15232: ,bcc.encumbrance_type_id
15233: ,bcc.document_header_id_2
15234: ,bcc.document_distribution_type
15235: From Pa_Bc_Commitments_all bcc
15236: Where bcc.bc_commitment_id in (SELECT bcc1.bc_commitment_id
15237: FROM PA_BC_COMMITMENTS_ALL bcc1
15238: WHERE bcc1.document_header_id = p_sys_ref2
15239: AND bcc1.document_distribution_id = p_sys_ref3

Line 15237: FROM PA_BC_COMMITMENTS_ALL bcc1

15233: ,bcc.document_header_id_2
15234: ,bcc.document_distribution_type
15235: From Pa_Bc_Commitments_all bcc
15236: Where bcc.bc_commitment_id in (SELECT bcc1.bc_commitment_id
15237: FROM PA_BC_COMMITMENTS_ALL bcc1
15238: WHERE bcc1.document_header_id = p_sys_ref2
15239: AND bcc1.document_distribution_id = p_sys_ref3
15240: AND bcc1.parent_bc_packet_id = g_bc_packet_id_tbl(i)
15241: UNIOn ALL