APPS.OZF_SALES_TRANSACTIONS_PVT dependencies on OZF_RESALE_LINES_INT_ALL

Line 758: FROM ozf_resale_lines_int_all rli

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

Line 790: FROM ozf_resale_lines_int_all rli

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

Line 840: FROM ozf_resale_lines_int_all rli

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

Line 870: FROM ozf_resale_lines_int_all rli

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