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.CSD_BULK_RECEIVE_UTIL dependencies on CSI_I_PARTIES

Line 632: FROM csi_i_parties

628: Else
629: BEGIN
630: SELECT relationship_type_code
631: INTO l_relationship
632: FROM csi_i_parties
633: WHERE instance_id = l_instance_id
634: AND party_id = p_party_id
635: AND SYSDATE BETWEEN NVL(active_start_date, SYSDATE - 1) AND NVL(active_end_date,SYSDATE+1)
636: AND relationship_type_code = NVL(l_crt_inst_party_relation,relationship_type_code)

Line 1556: from csi_i_parties

1552: -- Cursor to select the Instance party id
1553: Cursor c_instance_party(p_instance_id number) IS
1554: Select instance_party_id,
1555: object_version_number
1556: from csi_i_parties
1557: where instance_id = p_instance_id
1558: and relationship_type_code = 'OWNER';
1559:
1560: -- Cursor to derive the Instance details

Line 1589: (SELECT instance_party_id FROM CSI_I_PARTIES

1585: Cursor get_bill_to_ship_to_address(p_instance_id number) IS
1586: SELECT bill_to_address,ship_to_address
1587: FROM CSI_IP_ACCOUNTS
1588: WHERE INSTANCE_PARTY_ID =
1589: (SELECT instance_party_id FROM CSI_I_PARTIES
1590: WHERE INSTANCE_ID=p_instance_id
1591: AND relationship_type_code='OWNER');
1592: --bug#8508030
1593: