DBA Data[Home] [Help]

APPS.CSM_MTL_SEC_INV_EVENT_PKG dependencies on ASG_USER

Line 178: from csp_sec_inventories csi,asg_user au

174: AND csi.last_update_date >= p_last_upd_date;
175:
176: CURSOR c_ins_cur IS -- sub inventories of dest org
177: select CSM_MTL_SEC_INV_ACC_S.nextval as access_id,au.user_id , csi.organization_id,csi.secondary_inventory_name
178: from csp_sec_inventories csi,asg_user au
179: where au.enabled='Y' and au.multi_platform='Y'
180: --AND csi.CONDITION_TYPE='G'
181: AND EXISTS(SELECT 1 FROM mtl_secondary_inventories msi WHERE csi.organization_id=msi.organization_id AND csi.secondary_inventory_name=msi.secondary_inventory_name
182: AND nvl(msi.disable_date,sysdate+1)>=sysdate)