DBA Data[Home] [Help]

APPS.OE_CNCL_VALIDATE_LINE dependencies on MTL_CUSTOMER_ITEMS

Line 609: FROM mtl_customer_items citems

605: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
606: ELSIF nvl(p_item_identifier_type, 'INT') = 'CUST' THEN
607: SELECT 'valid'
608: INTO l_dummy
609: FROM mtl_customer_items citems
610: ,mtl_customer_item_xrefs cxref
611: ,mtl_system_items_vl sitems
612: WHERE citems.customer_item_id = cxref.customer_item_id
613: AND cxref.inventory_item_id = sitems.inventory_item_id