DBA Data[Home] [Help]

APPS.CTO_WIP_UTIL dependencies on MTL_CUSTOMER_ITEMS

Line 699: mtl_customer_items mci

695: BEGIN
696: select 1
697: into l_eligible_line
698: from oe_order_lines_all oel,
699: mtl_customer_items mci
700: where oel.line_id = p_line_id
701: and oel.ordered_item_id = mci.customer_item_id (+)
702: and ((oel.item_identifier_type <> 'CUST')
703: or (oel.item_identifier_type = 'CUST'

Line 739: mtl_customer_items mci

735: from oe_order_lines_all oel
736: where exists (select 'Exists'
737: from WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
738: wsh_delivery_assignments wda,
739: mtl_customer_items mci
740: where wdd.source_line_id = oel.line_id
741: and mci.customer_item_id = oel.ordered_item_id
742: and wda.delivery_detail_id = wdd.delivery_detail_id
743: and mci.dep_plan_prior_bld_flag = 'Y'