APPS.GMD_COA_DATA_OM_NEW dependencies on HZ_PARTIES

Line 698: hz_parties b

694: CURSOR c_get_cust(p_cust_id IN NUMBER) IS
695: select a.account_number cust_no,
696: b.party_name cust_name
697: from hz_cust_accounts a,
698: hz_parties b
699: where a.party_id = b.party_id
700: and a.cust_account_id = p_cust_id;
701:
702: --INVCONV

Line 1581: hz_parties pr

1577: mtl_system_items_b_kfv msi, --INVCONV
1578: hz_cust_accounts c,
1579: hz_cust_site_uses_all s,
1580: hz_cust_acct_sites_all a,
1581: hz_parties pr
1582: where h.header_id = l.header_id
1583: and l.header_id = wdd.source_header_id
1584: and l.line_id = wdd.source_line_id
1585: and wnd.delivery_id = wda.delivery_id

Line 1664: hz_parties pr

1660: mtl_system_items_b_kfv msi, --INVCONV
1661: hz_cust_accounts c,
1662: hz_cust_site_uses_all s,
1663: hz_cust_acct_sites_all a,
1664: hz_parties pr
1665: where h.header_id = l.header_id
1666: and l.header_id = wdd.source_header_id
1667: and l.line_id = wdd.source_line_id
1668: and wnd.delivery_id = wda.delivery_id

Line 1726: hz_parties pr

1722: mtl_system_items_b_kfv msi, --INVCONV
1723: hz_cust_accounts c,
1724: hz_cust_site_uses_all s,
1725: hz_cust_acct_sites_all a,
1726: hz_parties pr
1727: where h.header_id = l.header_id
1728: and (p_order_id IS NULL OR h.header_id = p_order_id)
1729: and (p_org_id IS NULL OR a.org_id = p_org_id)
1730: and (p_cust_id IS NULL OR l.sold_to_org_id = p_cust_id)