DBA Data[Home] [Help]

APPS.CSM_ITEM_INSTANCE_EVENT_PKG dependencies on CSM_MTL_ONHAND_QTY_ACC

Line 338: FROM csm_mtl_onhand_qty_acc ohqacc

334: AND asg.user_id = asg.owner_id
335: AND asg.user_id = acc.user_id
336: AND NOT EXISTS
337: (SELECT 1
338: FROM csm_mtl_onhand_qty_acc ohqacc
339: WHERE ohqacc.user_id = acc.user_id
340: AND ohqacc.inventory_item_id = cii.inventory_item_id
341: AND ohqacc.organization_id = cii.inv_organization_id
342: AND ohqacc.subinventory_code = cii.inv_subinventory_name

Line 375: FROM csm_mtl_onhand_qty_acc cqa

371: cqa.user_id,
372: cii.instance_id,
373: civ.version_label,
374: CIR.OBJECT_ID
375: FROM csm_mtl_onhand_qty_acc cqa
376: , csi_item_instances cii
377: , csi_instance_statuses iis
378: , asg_user asg
379: , csi_i_version_labels civ