APPS.QA_MQA_MWA_API dependencies on WSH_DELIVERY_DETAILS

Line 96: from wsh_delivery_details wdd, qa_customers_lov_v rc

92: msik.organization_id = orgID;
93:
94: cursor Customer(lpnID NUMBER) is
95: select wdd.customer_id, rc.customer_name
96: from wsh_delivery_details wdd, qa_customers_lov_v rc
97: where wdd.lpn_id = lpnID and
98: wdd.customer_id = rc.customer_id;
99:
100: cursor ShipToLocation(lpnID NUMBER) is

Line 102: from wsh_delivery_details wdd, hr_locations_all_tl tl

98: wdd.customer_id = rc.customer_id;
99:
100: cursor ShipToLocation(lpnID NUMBER) is
101: select wdd.ship_to_location_id, tl.description
102: from wsh_delivery_details wdd, hr_locations_all_tl tl
103: where wdd.lpn_id = lpnID and
104: wdd.ship_to_location_id = tl.location_id and
105: tl.language = userenv('LANG')
106: union

Line 109: from wsh_delivery_details wdd, hz_locations hz

105: tl.language = userenv('LANG')
106: union
107: select wdd.ship_to_location_id,
108: substr(hz.address1,1,50) description
109: from wsh_delivery_details wdd, hz_locations hz
110: where wdd.lpn_id = lpnID and
111: wdd.ship_to_location_id = hz.location_id;
112:
113: BEGIN