DBA Data[Home] [Help]

APPS.OE_BULK_PROCESS_LINE dependencies on MTL_CUSTOMER_ITEMS

Line 1136: FROM mtl_customer_items citems

1132: --Bug 1678296 chhung modify BEGIN
1133: IF p_line_category_code ='ORDER' THEN
1134: SELECT 'valid'
1135: INTO l_dummy
1136: FROM mtl_customer_items citems
1137: ,mtl_customer_item_xrefs cxref
1138: ,mtl_system_items_vl sitems
1139: WHERE citems.customer_item_id = cxref.customer_item_id
1140: AND cxref.inventory_item_id = sitems.inventory_item_id

Line 1151: FROM mtl_customer_items citems

1147: AND cxref.inactive_flag = 'N';
1148: ELSE /* line_category_code is 'RETURN'*/
1149: SELECT 'valid'
1150: INTO l_dummy
1151: FROM mtl_customer_items citems
1152: ,mtl_customer_item_xrefs cxref
1153: ,mtl_system_items_vl sitems
1154: WHERE citems.customer_item_id = cxref.customer_item_id
1155: AND cxref.inventory_item_id = sitems.inventory_item_id