APPS.MRP_CREATE_SCHEDULE_ISO dependencies on OE_SHIP_TO_ORGS_V

Line 140: from oe_ship_to_orgs_v org, hz_parties hp, hz_cust_accounts hca

136: and rownum < 2;
137:
138: CURSOR c_ship_to_location_id(p_customer_id number, p_site_use_id number) IS
139: select org.organization_id
140: from oe_ship_to_orgs_v org, hz_parties hp, hz_cust_accounts hca
141: where org.customer_id = hca.cust_account_id
142: and hp.party_id = hca.party_id
143: and hca.cust_account_id = p_customer_id
144: and org.site_use_id = p_site_use_id