DBA Data[Home] [Help]

APPS.WSH_UTIL_VALIDATE dependencies on MTL_CUSTOMER_ITEMS

Line 4048: FROM mtl_customer_items

4044:
4045: CURSOR c_default_container(l_customer_item_id NUMBER) IS
4046: SELECT master_container_item_id,
4047: detail_container_item_id
4048: FROM mtl_customer_items
4049: WHERE customer_item_id = l_customer_item_id;
4050: --
4051:
4052: BEGIN

Line 5834: from mtl_customer_items mci

5830: select cust_items.customer_item_id
5831: into x_customer_item_id
5832: from
5833: ( select mci.customer_item_id, mci.item_definition_level
5834: from mtl_customer_items mci
5835: where mci.customer_item_number = p_item_number
5836: and mci.customer_id = p_customer_id
5837: and mci.item_definition_level = 1
5838: union

Line 5840: from mtl_customer_items mci1

5836: and mci.customer_id = p_customer_id
5837: and mci.item_definition_level = 1
5838: union
5839: select mci1.customer_item_id, mci1.item_definition_level
5840: from mtl_customer_items mci1
5841: where mci1.customer_item_number = p_item_number
5842: and mci1.customer_id = p_customer_id
5843: and mci1.address_id = p_address_id
5844: and mci1.item_definition_level = 3