APPS.CLN_SYNC_INVENTORY_PKG dependencies on MTL_CUSTOMER_ITEM_XREFS

Line 451: mtl_customer_item_xrefs mcix

447: SELECT mci.customer_item_number
448: INTO x_customer_item_number
449: FROM
450: mtl_customer_items mci ,
451: mtl_customer_item_xrefs mcix
452: WHERE mcix.master_organization_id = p_inv_org
453: AND mcix.inventory_item_id = p_item_number
454: AND mci.customer_id = p_tp_id
455: AND mci.customer_item_id(+) = mcix.customer_item_id;