DBA Data[Home] [Help]

APPS.MST_REPORTS_PKG dependencies on HZ_PARTIES

Line 6362: , hz_parties hzp

6358: , 0, 1
6359: , mst_reports_pkg.get_plan_value(p_plan_id,p_report_for,p_report_for_id)) ) * 100
6360: ,0
6361: from mst_plans mp
6362: , hz_parties hzp
6363: , hz_cust_accounts hzc
6364: WHERE mp.plan_id = p_plan_id
6365: and hzp.party_id = hzc.party_id
6366: and hzc.cust_account_id in (select distinct md.customer_id

Line 6439: , hz_parties hz

6435: ,0
6436: from mst_plans mp
6437: , po_vendors pov
6438: , hz_relationships hzr
6439: , hz_parties hz
6440: WHERE mp.plan_id = p_plan_id
6441: and pov.vendor_id = hzr.subject_id
6442: and hzr.object_id = hz.party_id
6443: and hzr.relationship_type = 'POS_VENDOR_PARTY'