DBA Data[Home] [Help]

APPS.OE_BULK_PROCESS_LINE dependencies on MTL_CUSTOMER_ITEM_XREFS

Line 1163: ,mtl_customer_item_xrefs cxref

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
1167: AND sitems.inventory_item_id = p_inventory_item_id

Line 1178: ,mtl_customer_item_xrefs cxref

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
1182: AND sitems.inventory_item_id = p_inventory_item_id