VIEW: APPS.CSM_INV_LOC_ASS_V

Source

View Text - Preformatted

SELECT acc.access_id , cila.csp_inv_loc_assignment_id , cila.organization_id , cila.subinventory_code , cila.locator_id , cila.default_code, secinv.location_id, secinv.condition_type, secinv.autoreceipt_flag, secinv.spares_location_flag, cila.effective_date_start, cila.effective_date_end,cila.RESOURCE_ID , cila.RESOURCE_TYPE , secinv.owner_RESOURCE_ID , secinv.owner_RESOURCE_TYPE FROM csm_inv_loc_ass_acc acc, csp_inv_loc_assignments cila, csp_sec_inventories secinv WHERE acc.user_id = asg_base.get_user_id AND acc.csp_inv_loc_assignment_id = cila.csp_inv_loc_assignment_id AND SYSDATE BETWEEN nvl(cila.effective_date_start, sysdate) AND nvl(cila.effective_date_end, sysdate) AND secinv.organization_id = cila.organization_id AND secinv.secondary_inventory_name = cila.subinventory_code

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, CILA.CSP_INV_LOC_ASSIGNMENT_ID
, CILA.ORGANIZATION_ID
, CILA.SUBINVENTORY_CODE
, CILA.LOCATOR_ID
, CILA.DEFAULT_CODE
, SECINV.LOCATION_ID
, SECINV.CONDITION_TYPE
, SECINV.AUTORECEIPT_FLAG
, SECINV.SPARES_LOCATION_FLAG
, CILA.EFFECTIVE_DATE_START
, CILA.EFFECTIVE_DATE_END
, CILA.RESOURCE_ID
, CILA.RESOURCE_TYPE
, SECINV.OWNER_RESOURCE_ID
, SECINV.OWNER_RESOURCE_TYPE
FROM CSM_INV_LOC_ASS_ACC ACC
, CSP_INV_LOC_ASSIGNMENTS CILA
, CSP_SEC_INVENTORIES SECINV
WHERE ACC.USER_ID = ASG_BASE.GET_USER_ID
AND ACC.CSP_INV_LOC_ASSIGNMENT_ID = CILA.CSP_INV_LOC_ASSIGNMENT_ID
AND SYSDATE BETWEEN NVL(CILA.EFFECTIVE_DATE_START
, SYSDATE)
AND NVL(CILA.EFFECTIVE_DATE_END
, SYSDATE)
AND SECINV.ORGANIZATION_ID = CILA.ORGANIZATION_ID
AND SECINV.SECONDARY_INVENTORY_NAME = CILA.SUBINVENTORY_CODE