APPS.RLM_VALIDATEDEMAND_SV dependencies on MTL_CUSTOMER_ITEMS

Line 4884: FROM mtl_customer_items

4880: END IF;
4881: --
4882: SELECT customer_item_id
4883: INTO x_lines_rec.customer_item_id
4884: FROM mtl_customer_items
4885: WHERE customer_item_number = x_lines_rec.customer_item_ext
4886: AND customer_id = x_header_rec.customer_id
4887: AND address_id = x_lines_rec.ship_to_address_id
4888: AND item_definition_level = '3'

Line 4909: FROM mtl_customer_items mci

4905: --
4906: -- Following query is changed as per TCA obsolescence project.
4907: SELECT mci.customer_item_id
4908: INTO x_lines_rec.customer_item_id
4909: FROM mtl_customer_items mci
4910: WHERE mci.customer_item_number = x_lines_rec.customer_item_ext
4911: AND mci.customer_id = x_header_rec.customer_id
4912: AND x_lines_rec.ship_to_address_id IN
4913: (select cust_acct_site_id from hz_cust_acct_sites

Line 4933: FROM mtl_customer_items

4929: END IF;
4930: --
4931: SELECT customer_item_id
4932: INTO x_lines_rec.customer_item_id
4933: FROM mtl_customer_items
4934: WHERE customer_item_number = x_lines_rec.customer_item_ext
4935: AND address_id IS NULL
4936: AND customer_id = x_header_rec.customer_id
4937: AND item_definition_level = '1'