DBA Data[Home] [Help]

APPS.OZF_SALES_TRANSACTIONS_PVT dependencies on OZF_RESALE_LINES_INT_ALL

Line 740: FROM ozf_resale_lines_int_all rli

736: FROM ozf_sales_transactions_all stn
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

Line 772: FROM ozf_resale_lines_int_all rli

768: FROM ozf_sales_transactions_all stn
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

Line 822: FROM ozf_resale_lines_int_all rli

818: WHERE stn.transaction_date > p_start_date
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

Line 852: FROM ozf_resale_lines_int_all rli

848: WHERE stn.transaction_date > p_start_date
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