DBA Data[Home] [Help]

APPS.GMD_COA_DATA_OM_NEW dependencies on HZ_PARTIES

Line 655: hz_parties b

651: CURSOR c_get_cust(p_cust_id IN NUMBER) IS
652: select a.account_number cust_no,
653: b.party_name cust_name
654: from hz_cust_accounts a,
655: hz_parties b
656: where a.party_id = b.party_id
657: and a.cust_account_id = p_cust_id;
658:
659: --INVCONV

Line 1489: hz_parties pr

1485: mtl_system_items_b_kfv msi, --INVCONV
1486: hz_cust_accounts c,
1487: hz_cust_site_uses_all s,
1488: hz_cust_acct_sites_all a,
1489: hz_parties pr
1490: where h.header_id = l.header_id
1491: and l.header_id = wdd.source_header_id
1492: and l.line_id = wdd.source_line_id
1493: and wnd.delivery_id = wda.delivery_id

Line 1550: hz_parties pr

1546: mtl_system_items_b_kfv msi, --INVCONV
1547: hz_cust_accounts c,
1548: hz_cust_site_uses_all s,
1549: hz_cust_acct_sites_all a,
1550: hz_parties pr
1551: where h.header_id = l.header_id
1552: and (p_order_id IS NULL OR h.header_id = p_order_id)
1553: and (p_org_id IS NULL OR a.org_id = p_org_id)
1554: and (p_cust_id IS NULL OR l.sold_to_org_id = p_cust_id)