APPS.PV_SEED_DERIVED_PKG dependencies on OZF_SALES_TRANSACTIONS_ALL
Line 60: from ozf_sales_transactions_all a, hz_cust_accounts b, pv_partner_profiles c
56: is
57:
58: cursor lc_prod_sold (pc_partner_id number) is
59: select distinct a.inventory_item_id 60: from ozf_sales_transactions_all a, hz_cust_accounts b, pv_partner_profiles c 61: where c.partner_id = pc_partner_id
62: and c.partner_party_id = b.party_id
63: and b.cust_account_id = a.SOLD_FROM_CUST_ACCOUNT_ID
64: and a.transfer_type = 'S'