DBA Data[Home] [Help]

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'