DBA Data[Home] [Help]

APPS.CSM_ITEM_INSTANCE_EVENT_PKG dependencies on CSM_MTL_ONHAND_QTY_ACC

Line 337: FROM csm_mtl_onhand_qty_acc ohqacc

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

Line 376: FROM csm_mtl_onhand_qty_acc cqa

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