DBA Data[Home] [Help]

APPS.OE_BULK_PROCESS_LINE dependencies on MTL_CUSTOMER_ITEMS

Line 1162: FROM mtl_customer_items citems

1158: --Bug 1678296 chhung modify BEGIN
1159: IF p_line_category_code ='ORDER' THEN
1160: SELECT 'valid'
1161: INTO l_dummy
1162: FROM mtl_customer_items citems
1163: ,mtl_customer_item_xrefs cxref
1164: ,mtl_system_items_vl sitems
1165: WHERE citems.customer_item_id = cxref.customer_item_id
1166: AND cxref.inventory_item_id = sitems.inventory_item_id

Line 1177: FROM mtl_customer_items citems

1173: AND cxref.inactive_flag = 'N';
1174: ELSE /* line_category_code is 'RETURN'*/
1175: SELECT 'valid'
1176: INTO l_dummy
1177: FROM mtl_customer_items citems
1178: ,mtl_customer_item_xrefs cxref
1179: ,mtl_system_items_vl sitems
1180: WHERE citems.customer_item_id = cxref.customer_item_id
1181: AND cxref.inventory_item_id = sitems.inventory_item_id