DBA Data[Home] [Help]

APPS.CTO_WIP_UTIL dependencies on MTL_CUSTOMER_ITEMS

Line 681: mtl_customer_items mci

677: BEGIN
678: select 1
679: into l_eligible_line
680: from oe_order_lines_all oel,
681: mtl_customer_items mci
682: where oel.line_id = p_line_id
683: and oel.ordered_item_id = mci.customer_item_id (+)
684: and ((oel.item_identifier_type <> 'CUST')
685: or (oel.item_identifier_type = 'CUST'

Line 721: mtl_customer_items mci

717: from oe_order_lines_all oel
718: where exists (select 'Exists'
719: from WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
720: wsh_delivery_assignments wda,
721: mtl_customer_items mci
722: where wdd.source_line_id = oel.line_id
723: and mci.customer_item_id = oel.ordered_item_id
724: and wda.delivery_detail_id = wdd.delivery_detail_id
725: and mci.dep_plan_prior_bld_flag = 'Y'