VIEW: APPS.CSF_M_ITEM_INSTANCES_V

Source

View Text - Preformatted

SELECT acc.access_id , cii.INSTANCE_ID , cii.INSTANCE_NUMBER , cii.INVENTORY_ITEM_ID , cii.INVENTORY_REVISION , cii.INV_MASTER_ORGANIZATION_ID , cii.SERIAL_NUMBER , cii.LOT_NUMBER , cii.QUANTITY , cii.UNIT_OF_MEASURE , cii.INSTANCE_STATUS_ID , cii.LOCATION_ID , cii.INV_ORGANIZATION_ID , cii.INV_SUBINVENTORY_NAME , cii.INV_LOCATOR_ID , cii.INSTALL_DATE , cii.OWNER_PARTY_SOURCE_TABLE, cii.OWNER_PARTY_ID, cii.OWNER_PARTY_ACCOUNT_ID, NVL(cii.ACTIVE_START_DATE, SYSDATE), NVL(cii.ACTIVE_END_DATE, SYSDATE + 9999), cii.LOCATION_TYPE_CODE, msik.CONCATENATED_SEGMENTS as name , msik.DESCRIPTION as description , asg_base.get_user_name CLIENT_NAME, cii.context, cii.attribute1, cii.attribute2, cii.attribute3, cii.attribute4, cii.attribute5, cii.attribute6, cii.attribute7, cii.attribute8, cii.attribute9, cii.attribute10, cii.attribute11, cii.attribute12, cii.attribute13, cii.attribute14, cii.attribute15, acc.PARENT_INSTANCE_ID AS PARENT_INSTANCE_ID, CII.ACTUAL_RETURN_DATE, CII.CREATION_COMPLETE_FLAG, CII.COMPLETENESS_FLAG, CII.EXTERNAL_REFERENCE, CII.INSTALL_LOCATION_ID, CII.INSTALL_LOCATION_TYPE_CODE, CII.INSTANCE_TYPE_CODE, CII.INSTANCE_USAGE_CODE, CII.MFG_SERIAL_NUMBER_FLAG, CII.RETURN_BY_DATE, acc.version_label, cii.ACCOUNTING_CLASS_CODE, cii.LAST_OE_ORDER_LINE_ID, 'N' AS terminated_flag, cii.LAST_VLD_ORGANIZATION_ID, msik.MATERIAL_BILLABLE_FLAG FROM CSM_ITEM_INSTANCES_ACC acc , CSI_ITEM_INSTANCES cii , mtl_system_items_b_kfv msik WHERE acc.user_id = asg_base.get_user_id AND acc.instance_id = cii.instance_id AND msik.inventory_item_id = cii.inventory_item_id AND msik.organization_id = cii.inv_master_organization_id

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, CII.INSTANCE_ID
, CII.INSTANCE_NUMBER
, CII.INVENTORY_ITEM_ID
, CII.INVENTORY_REVISION
, CII.INV_MASTER_ORGANIZATION_ID
, CII.SERIAL_NUMBER
, CII.LOT_NUMBER
, CII.QUANTITY
, CII.UNIT_OF_MEASURE
, CII.INSTANCE_STATUS_ID
, CII.LOCATION_ID
, CII.INV_ORGANIZATION_ID
, CII.INV_SUBINVENTORY_NAME
, CII.INV_LOCATOR_ID
, CII.INSTALL_DATE
, CII.OWNER_PARTY_SOURCE_TABLE
, CII.OWNER_PARTY_ID
, CII.OWNER_PARTY_ACCOUNT_ID
, NVL(CII.ACTIVE_START_DATE
, SYSDATE)
, NVL(CII.ACTIVE_END_DATE
, SYSDATE + 9999)
, CII.LOCATION_TYPE_CODE
, MSIK.CONCATENATED_SEGMENTS AS NAME
, MSIK.DESCRIPTION AS DESCRIPTION
, ASG_BASE.GET_USER_NAME CLIENT_NAME
, CII.CONTEXT
, CII.ATTRIBUTE1
, CII.ATTRIBUTE2
, CII.ATTRIBUTE3
, CII.ATTRIBUTE4
, CII.ATTRIBUTE5
, CII.ATTRIBUTE6
, CII.ATTRIBUTE7
, CII.ATTRIBUTE8
, CII.ATTRIBUTE9
, CII.ATTRIBUTE10
, CII.ATTRIBUTE11
, CII.ATTRIBUTE12
, CII.ATTRIBUTE13
, CII.ATTRIBUTE14
, CII.ATTRIBUTE15
, ACC.PARENT_INSTANCE_ID AS PARENT_INSTANCE_ID
, CII.ACTUAL_RETURN_DATE
, CII.CREATION_COMPLETE_FLAG
, CII.COMPLETENESS_FLAG
, CII.EXTERNAL_REFERENCE
, CII.INSTALL_LOCATION_ID
, CII.INSTALL_LOCATION_TYPE_CODE
, CII.INSTANCE_TYPE_CODE
, CII.INSTANCE_USAGE_CODE
, CII.MFG_SERIAL_NUMBER_FLAG
, CII.RETURN_BY_DATE
, ACC.VERSION_LABEL
, CII.ACCOUNTING_CLASS_CODE
, CII.LAST_OE_ORDER_LINE_ID
, 'N' AS TERMINATED_FLAG
, CII.LAST_VLD_ORGANIZATION_ID
, MSIK.MATERIAL_BILLABLE_FLAG
FROM CSM_ITEM_INSTANCES_ACC ACC
, CSI_ITEM_INSTANCES CII
, MTL_SYSTEM_ITEMS_B_KFV MSIK
WHERE ACC.USER_ID = ASG_BASE.GET_USER_ID
AND ACC.INSTANCE_ID = CII.INSTANCE_ID
AND MSIK.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID
AND MSIK.ORGANIZATION_ID = CII.INV_MASTER_ORGANIZATION_ID