VIEW: APPS.CSM_MTL_SEC_INVENTORIES_V

Source

View Text - Preformatted

SELECT distinct acc.access_id, msi.secondary_inventory_name, msi.organization_id, msi.description, msi.asset_inventory,msi.source_type, msi.disable_date, msi.locator_type, msi.QUANTITY_TRACKED, MSI.SUBINVENTORY_USAGE , MSI.DEPRECIABLE_FLAG , msi.LOCATION_ID , MSI.STATUS_ID, hz_format_pub.format_address(cpp.hz_location_id), nvl(cpp.stocking_site_type, 'TECHNICIAN') ,csi.autoreceipt_flag,csi.return_organization_id return_org,csi.return_subinventory_name return_subinv,csi.condition_type FROM csm_mtl_sec_inv_acc acc, mtl_secondary_inventories msi,csp_planning_parameters cpp ,CSP_SEC_INVENTORIES csi WHERE acc.user_id = asg_base.get_user_id AND acc.secondary_inventory_name = msi.secondary_inventory_name AND acc.secondary_inventory_name = csi.secondary_inventory_name AND acc.organization_id = csi.organization_id AND acc.organization_id = msi.organization_id AND msi.organization_id=cpp.organization_id(+) AND msi.secondary_inventory_name=NVL(cpp.secondary_inventory(+),msi.secondary_inventory_name)

View Text - HTML Formatted

SELECT DISTINCT ACC.ACCESS_ID
, MSI.SECONDARY_INVENTORY_NAME
, MSI.ORGANIZATION_ID
, MSI.DESCRIPTION
, MSI.ASSET_INVENTORY
, MSI.SOURCE_TYPE
, MSI.DISABLE_DATE
, MSI.LOCATOR_TYPE
, MSI.QUANTITY_TRACKED
, MSI.SUBINVENTORY_USAGE
, MSI.DEPRECIABLE_FLAG
, MSI.LOCATION_ID
, MSI.STATUS_ID
, HZ_FORMAT_PUB.FORMAT_ADDRESS(CPP.HZ_LOCATION_ID)
, NVL(CPP.STOCKING_SITE_TYPE
, 'TECHNICIAN')
, CSI.AUTORECEIPT_FLAG
, CSI.RETURN_ORGANIZATION_ID RETURN_ORG
, CSI.RETURN_SUBINVENTORY_NAME RETURN_SUBINV
, CSI.CONDITION_TYPE
FROM CSM_MTL_SEC_INV_ACC ACC
, MTL_SECONDARY_INVENTORIES MSI
, CSP_PLANNING_PARAMETERS CPP
, CSP_SEC_INVENTORIES CSI
WHERE ACC.USER_ID = ASG_BASE.GET_USER_ID
AND ACC.SECONDARY_INVENTORY_NAME = MSI.SECONDARY_INVENTORY_NAME
AND ACC.SECONDARY_INVENTORY_NAME = CSI.SECONDARY_INVENTORY_NAME
AND ACC.ORGANIZATION_ID = CSI.ORGANIZATION_ID
AND ACC.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID=CPP.ORGANIZATION_ID(+)
AND MSI.SECONDARY_INVENTORY_NAME=NVL(CPP.SECONDARY_INVENTORY(+)
, MSI.SECONDARY_INVENTORY_NAME)