DBA Data[Home] [Help]

APPS.GMD_COA_DATA_OM_NEW dependencies on HZ_CUST_ACCOUNTS

Line 697: from hz_cust_accounts a,

693:
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:

Line 1578: hz_cust_accounts c,

1574: wsh_new_deliveries wnd,
1575: wsh_delivery_assignments wda,
1576: mtl_parameters ship_from_org,
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

Line 1661: hz_cust_accounts c,

1657: wsh_new_deliveries wnd,
1658: wsh_delivery_assignments wda,
1659: mtl_parameters ship_from_org,
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

Line 1723: hz_cust_accounts c,

1719: oe_order_headers_all h,
1720: oe_order_lines_all l,
1721: mtl_parameters ship_from_org,
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