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.OZF_SALES_TRANSACTIONS_PVT dependencies on HZ_CUST_ACCOUNTS

Line 741: , hz_cust_accounts hca

737: WHERE stn.transaction_date <= p_start_date
738: AND stn.source_code IN ('OM', 'MA')
739: AND stn.inventory_item_id IN ( SELECT rli.inventory_item_id
740: FROM ozf_resale_lines_int_all rli
741: , hz_cust_accounts hca
742: WHERE rli.resale_batch_id = p_resale_batch_id
743: --AND rli.sold_from_cust_account_id = stn.sold_to_cust_account_id
744: AND rli.sold_from_cust_account_id = hca.cust_account_id
745: AND hca.party_id = stn.sold_to_party_id

Line 773: , hz_cust_accounts hca

769: WHERE stn.transaction_date <= p_start_date
770: AND stn.source_code = 'IS'
771: AND stn.inventory_item_id IN ( SELECT rli.inventory_item_id
772: FROM ozf_resale_lines_int_all rli
773: , hz_cust_accounts hca
774: WHERE rli.resale_batch_id = p_resale_batch_id
775: --AND rli.sold_from_cust_account_id = stn.sold_from_cust_account_id
776: --AND rli.sold_from_cust_account_id = stn.sold_to_cust_account_id
777: AND rli.sold_from_cust_account_id = hca.cust_account_id

Line 823: , hz_cust_accounts hca

819: AND stn.transaction_date <= p_end_date
820: AND stn.source_code IN ('OM', 'MA')
821: AND stn.inventory_item_id IN ( SELECT rli.inventory_item_id
822: FROM ozf_resale_lines_int_all rli
823: , hz_cust_accounts hca
824: WHERE rli.resale_batch_id = p_resale_batch_id
825: --AND rli.sold_from_cust_account_id = stn.sold_to_cust_account_id
826: AND rli.sold_from_cust_account_id = hca.cust_account_id
827: AND hca.party_id = stn.sold_to_party_id

Line 853: , hz_cust_accounts hca

849: AND stn.transaction_date <= p_end_date
850: AND source_code = 'IS'
851: AND stn.inventory_item_id IN ( SELECT rli.inventory_item_id
852: FROM ozf_resale_lines_int_all rli
853: , hz_cust_accounts hca
854: WHERE rli.resale_batch_id = p_resale_batch_id
855: --AND rli.sold_from_cust_account_id = stn.sold_from_cust_account_id
856: AND rli.sold_from_cust_account_id = hca.cust_account_id
857: AND hca.party_id = stn.sold_to_party_id

Line 1146: FROM hz_cust_accounts

1142: AND rownum = 1;
1143:
1144: CURSOR csr_sold_from_party_id (cv_cust_account_id IN NUMBER) IS
1145: SELECT party_id
1146: FROM hz_cust_accounts
1147: WHERE cust_account_id = cv_cust_account_id;
1148:
1149: l_sold_from_party_id NUMBER;
1150: -- Bug 4380203 (-)