VIEW: APPS.CSM_MTL_ITEM_SUBINV_V

Source

View Text - Preformatted

SELECT acc.access_id, mis.inventory_item_id , mis.organization_id , mis.secondary_inventory FROM csm_mtl_item_subinv_acc acc, mtl_item_sub_inventories mis WHERE acc.user_id = asg_base.get_user_id AND acc.inventory_item_id = mis.inventory_item_id AND acc.organization_id = mis.organization_id AND acc.secondary_inventory = mis.secondary_inventory

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, MIS.INVENTORY_ITEM_ID
, MIS.ORGANIZATION_ID
, MIS.SECONDARY_INVENTORY
FROM CSM_MTL_ITEM_SUBINV_ACC ACC
, MTL_ITEM_SUB_INVENTORIES MIS
WHERE ACC.USER_ID = ASG_BASE.GET_USER_ID
AND ACC.INVENTORY_ITEM_ID = MIS.INVENTORY_ITEM_ID
AND ACC.ORGANIZATION_ID = MIS.ORGANIZATION_ID
AND ACC.SECONDARY_INVENTORY = MIS.SECONDARY_INVENTORY