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 759: , hz_cust_accounts hca

755: WHERE stn.transaction_date <= p_start_date
756: AND stn.source_code IN ('OM', 'MA')
757: AND stn.inventory_item_id IN ( SELECT rli.inventory_item_id
758: FROM ozf_resale_lines_int_all rli
759: , hz_cust_accounts hca
760: WHERE rli.resale_batch_id = p_resale_batch_id
761: --AND rli.sold_from_cust_account_id = stn.sold_to_cust_account_id
762: AND rli.sold_from_cust_account_id = hca.cust_account_id
763: -- AND hca.party_id = stn.sold_to_party_id -- fix for bug 14761031

Line 791: , hz_cust_accounts hca

787: WHERE stn.transaction_date <= p_start_date
788: AND stn.source_code = 'IS'
789: AND stn.inventory_item_id IN ( SELECT rli.inventory_item_id
790: FROM ozf_resale_lines_int_all rli
791: , hz_cust_accounts hca
792: WHERE rli.resale_batch_id = p_resale_batch_id
793: --AND rli.sold_from_cust_account_id = stn.sold_from_cust_account_id
794: --AND rli.sold_from_cust_account_id = stn.sold_to_cust_account_id
795: AND rli.sold_from_cust_account_id = hca.cust_account_id

Line 841: , hz_cust_accounts hca

837: AND stn.transaction_date <= p_end_date
838: AND stn.source_code IN ('OM', 'MA')
839: AND stn.inventory_item_id IN ( SELECT rli.inventory_item_id
840: FROM ozf_resale_lines_int_all rli
841: , hz_cust_accounts hca
842: WHERE rli.resale_batch_id = p_resale_batch_id
843: --AND rli.sold_from_cust_account_id = stn.sold_to_cust_account_id
844: AND rli.sold_from_cust_account_id = hca.cust_account_id
845: -- AND hca.party_id = stn.sold_to_party_id -- fix for bug 14761031

Line 871: , hz_cust_accounts hca

867: AND stn.transaction_date <= p_end_date
868: AND source_code = 'IS'
869: AND stn.inventory_item_id IN ( SELECT rli.inventory_item_id
870: FROM ozf_resale_lines_int_all rli
871: , hz_cust_accounts hca
872: WHERE rli.resale_batch_id = p_resale_batch_id
873: --AND rli.sold_from_cust_account_id = stn.sold_from_cust_account_id
874: AND rli.sold_from_cust_account_id = hca.cust_account_id
875: -- AND hca.party_id = stn.sold_to_party_id -- fix for bug 14761031

Line 1164: FROM hz_cust_accounts

1160: AND rownum = 1;
1161:
1162: CURSOR csr_sold_from_party_id (cv_cust_account_id IN NUMBER) IS
1163: SELECT party_id
1164: FROM hz_cust_accounts
1165: WHERE cust_account_id = cv_cust_account_id;
1166:
1167: l_sold_from_party_id NUMBER;
1168: -- Bug 4380203 (-)