VIEW: APPS.MTL_PHYSICAL_INVENTORY_TAGS_V

Source

View Text - Preformatted

SELECT m.ROWID row_id , m.tag_id , m.physical_inventory_id , m.organization_id , m.last_update_date , m.last_updated_by , m.creation_date , m.created_by , m.last_update_login , m.void_flag , m.tag_number , m.adjustment_id , m.inventory_item_id , msi.description item_description , msi.revision_qty_control_code , msi.lot_control_code , msi.serial_number_control_code , msi.location_control_code , m.tag_quantity , m.tag_uom , m.tag_quantity_at_standard_uom , m.standard_uom , m.subinventory , m.locator_id , m.lot_number , m.revision , m.serial_num , m.counted_by_employee_id , m.attribute_category , m.attribute1 , m.attribute2 , m.attribute3 , m.attribute4 , m.attribute5 , m.attribute6 , m.attribute7 , m.attribute8 , m.attribute9 , m.attribute10 , m.attribute11 , m.attribute12 , m.attribute13 , m.attribute14 , m.attribute15 , m.parent_lpn_id , m.outermost_lpn_id , lpn1.license_plate_number parent_lpn , lpn2.license_plate_number outermost_lpn , lpn1.inventory_item_id container_item_id , lpn1.revision container_revision , lpn1.lot_number container_lot_number , lpn1.serial_number container_serial_number , m.cost_group_id , cg.cost_group cost_group_name , lpn1.cost_group_id container_cost_group_id , cg2.cost_group container_cost_group_name , m.lot_expiration_date , msi.shelf_life_days , msi.shelf_life_code , M.TAG_SECONDARY_QUANTITY , M.TAG_SECONDARY_UOM , M.TAG_QTY_AT_STD_SECONDARY_UOM , M.STANDARD_SECONDARY_UOM FROM mtl_physical_inventory_tags m , mtl_system_items msi , wms_license_plate_numbers lpn1 , wms_license_plate_numbers lpn2 , cst_cost_groups cg , cst_cost_groups cg2 WHERE m.inventory_item_id = msi.inventory_item_id(+) AND m.organization_id = msi.organization_id(+) AND m.parent_lpn_id = lpn1.lpn_id(+) AND m.outermost_lpn_id = lpn2.lpn_id(+) AND m.cost_group_id = cg.cost_group_id(+) AND lpn1.cost_group_id = cg2.cost_group_id(+)

View Text - HTML Formatted

SELECT M.ROWID ROW_ID
, M.TAG_ID
, M.PHYSICAL_INVENTORY_ID
, M.ORGANIZATION_ID
, M.LAST_UPDATE_DATE
, M.LAST_UPDATED_BY
, M.CREATION_DATE
, M.CREATED_BY
, M.LAST_UPDATE_LOGIN
, M.VOID_FLAG
, M.TAG_NUMBER
, M.ADJUSTMENT_ID
, M.INVENTORY_ITEM_ID
, MSI.DESCRIPTION ITEM_DESCRIPTION
, MSI.REVISION_QTY_CONTROL_CODE
, MSI.LOT_CONTROL_CODE
, MSI.SERIAL_NUMBER_CONTROL_CODE
, MSI.LOCATION_CONTROL_CODE
, M.TAG_QUANTITY
, M.TAG_UOM
, M.TAG_QUANTITY_AT_STANDARD_UOM
, M.STANDARD_UOM
, M.SUBINVENTORY
, M.LOCATOR_ID
, M.LOT_NUMBER
, M.REVISION
, M.SERIAL_NUM
, M.COUNTED_BY_EMPLOYEE_ID
, M.ATTRIBUTE_CATEGORY
, M.ATTRIBUTE1
, M.ATTRIBUTE2
, M.ATTRIBUTE3
, M.ATTRIBUTE4
, M.ATTRIBUTE5
, M.ATTRIBUTE6
, M.ATTRIBUTE7
, M.ATTRIBUTE8
, M.ATTRIBUTE9
, M.ATTRIBUTE10
, M.ATTRIBUTE11
, M.ATTRIBUTE12
, M.ATTRIBUTE13
, M.ATTRIBUTE14
, M.ATTRIBUTE15
, M.PARENT_LPN_ID
, M.OUTERMOST_LPN_ID
, LPN1.LICENSE_PLATE_NUMBER PARENT_LPN
, LPN2.LICENSE_PLATE_NUMBER OUTERMOST_LPN
, LPN1.INVENTORY_ITEM_ID CONTAINER_ITEM_ID
, LPN1.REVISION CONTAINER_REVISION
, LPN1.LOT_NUMBER CONTAINER_LOT_NUMBER
, LPN1.SERIAL_NUMBER CONTAINER_SERIAL_NUMBER
, M.COST_GROUP_ID
, CG.COST_GROUP COST_GROUP_NAME
, LPN1.COST_GROUP_ID CONTAINER_COST_GROUP_ID
, CG2.COST_GROUP CONTAINER_COST_GROUP_NAME
, M.LOT_EXPIRATION_DATE
, MSI.SHELF_LIFE_DAYS
, MSI.SHELF_LIFE_CODE
, M.TAG_SECONDARY_QUANTITY
, M.TAG_SECONDARY_UOM
, M.TAG_QTY_AT_STD_SECONDARY_UOM
, M.STANDARD_SECONDARY_UOM
FROM MTL_PHYSICAL_INVENTORY_TAGS M
, MTL_SYSTEM_ITEMS MSI
, WMS_LICENSE_PLATE_NUMBERS LPN1
, WMS_LICENSE_PLATE_NUMBERS LPN2
, CST_COST_GROUPS CG
, CST_COST_GROUPS CG2
WHERE M.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND M.ORGANIZATION_ID = MSI.ORGANIZATION_ID(+)
AND M.PARENT_LPN_ID = LPN1.LPN_ID(+)
AND M.OUTERMOST_LPN_ID = LPN2.LPN_ID(+)
AND M.COST_GROUP_ID = CG.COST_GROUP_ID(+)
AND LPN1.COST_GROUP_ID = CG2.COST_GROUP_ID(+)