DBA Data[Home] [Help]

APPS.GMD_COA_DATA_OM_NEW dependencies on HZ_CUST_ACCOUNTS

Line 654: from hz_cust_accounts a,

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

Line 1486: hz_cust_accounts c,

1482: wsh_new_deliveries wnd,
1483: wsh_delivery_assignments wda,
1484: mtl_parameters ship_from_org,
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

Line 1547: hz_cust_accounts c,

1543: oe_order_headers_all h,
1544: oe_order_lines_all l,
1545: mtl_parameters ship_from_org,
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