VIEW: APPS.CSM_MTL_SECONDARY_LOCATORS_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, B.INVENTORY_ITEM_ID , B.ORGANIZATION_ID , B.SECONDARY_LOCATOR , B.PRIMARY_LOCATOR_FLAG , B.SUBINVENTORY_CODE, B.STATUS_ID FROM MTL_SECONDARY_LOCATORS B, CSM_MTL_SECONDARY_LOCATORS_ACC ACC WHERE B.INVENTORY_ITEM_ID = ACC.INVENTORY_ITEM_ID AND B.SECONDARY_LOCATOR = ACC.SECONDARY_LOCATOR AND B.ORGANIZATION_ID = ACC.ORGANIZATION_ID AND ACC.USER_ID = ASG_BASE.GET_USER_ID

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.INVENTORY_ITEM_ID
, B.ORGANIZATION_ID
, B.SECONDARY_LOCATOR
, B.PRIMARY_LOCATOR_FLAG
, B.SUBINVENTORY_CODE
, B.STATUS_ID
FROM MTL_SECONDARY_LOCATORS B
, CSM_MTL_SECONDARY_LOCATORS_ACC ACC
WHERE B.INVENTORY_ITEM_ID = ACC.INVENTORY_ITEM_ID
AND B.SECONDARY_LOCATOR = ACC.SECONDARY_LOCATOR
AND B.ORGANIZATION_ID = ACC.ORGANIZATION_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID