View: CSI_TXN_ERRORS_V

Product:	CSI - Install Base
Description:	This is a view used for the display of data in the transactions error corrections form.
Implementation/DBA Data:	APPS.CSI_TXN_ERRORS_V

View Text

SELECT CTE.TRANSACTION_ERROR_ID TRANSACTION_ERROR_ID
, CTE.TRANSACTION_ID TRANSACTION_ID
, CTE.SOURCE_TYPE SOURCE_TYPE
, CTE.SOURCE_ID SOURCE_ID
, CTE.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, CTE.INV_MATERIAL_TRANSACTION_ID INV_MATERIAL_TRANSACTION_ID
, CTE.TRANSACTION_ERROR_DATE TRANSACTION_ERROR_DATE
, MMT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MMT.ORGANIZATION_ID INV_ORGANIZATION_ID
, MMT.REVISION REVISION
, MMT.SUBINVENTORY_CODE INV_SUBINVENTORY
, MMT.LOCATOR_ID LOCATOR_ID
, NULL LOT_NUMBER
, MUT.SERIAL_NUMBER SERIAL_NUMBER
, MMT.TRANSACTION_QUANTITY SHIPPED_QUANTITY
, MMT.TRANSACTION_UOM TRANSACTION_UOM
, MMT.TRANSACTION_DATE TRANSACTION_DATE
, MSI.RESERVABLE_TYPE RESERVABLE_TYPE
, HAOU.LOCATION_ID HR_LOCATION_ID
, MSEI.LOCATION_ID SUBINV_LOCATION_ID
, CTE.PROCESSED_FLAG PROCESSED_FLAG
, CTE.SRC_LOT_CTRL_CODE SRC_LOT_CTRL_CODE
, CTE.SRC_SERIAL_NUM_CTRL_CODE SRC_SERIAL_NUM_CTRL_CODE
, CTE.SRC_LOCATION_CTRL_CODE SRC_LOCATION_CTRL_CODE
, CTE.SRC_REV_QTY_CTRL_CODE SRC_REV_QTY_CTRL_CODE
, CTE.DST_LOT_CTRL_CODE DST_LOT_CTRL_CODE
, CTE.DST_SERIAL_NUM_CTRL_CODE DST_SERIAL_NUM_CTRL_CODE
, CTE.DST_LOCATION_CTRL_CODE DST_LOCATION_CTRL_CODE
, CTE.DST_REV_QTY_CTRL_CODE DST_REV_QTY_CTRL_CODE
, CTE.COMMS_NL_TRACKABLE_FLAG COMMS_NL_TRACKABLE_FLAG
FROM CSI_TXN_ERRORS CTE
, MTL_SYSTEM_ITEMS MSI
, MTL_UNIT_TRANSACTIONS MUT
, MTL_MATERIAL_TRANSACTIONS MMT
, MTL_SECONDARY_INVENTORIES MSEI
, HR_ALL_ORGANIZATION_UNITS HAOU
WHERE MMT.TRANSACTION_ID(+) = CTE.INV_MATERIAL_TRANSACTION_ID
AND MMT.TRANSACTION_ID = MUT.TRANSACTION_ID(+)
AND MSI.ORGANIZATION_ID = MMT.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MMT.INVENTORY_ITEM_ID
AND MSI.LOT_CONTROL_CODE = 1
AND MMT.ORGANIZATION_ID = HAOU.ORGANIZATION_ID(+)
AND MMT.SUBINVENTORY_CODE = MSEI.SECONDARY_INVENTORY_NAME(+)
AND MMT.ORGANIZATION_ID = MSEI.ORGANIZATION_ID(+) UNION SELECT CTE.TRANSACTION_ERROR_ID TRANSACTION_ERROR_ID
, CTE.TRANSACTION_ID TRANSACTION_ID
, CTE.SOURCE_TYPE SOURCE_TYPE
, CTE.SOURCE_ID SOURCE_ID
, CTE.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, CTE.INV_MATERIAL_TRANSACTION_ID INV_MATERIAL_TRANSACTION_ID
, CTE.TRANSACTION_ERROR_DATE TRANSACTION_ERROR_DATE
, MMT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MMT.ORGANIZATION_ID INV_ORGANIZATION_ID
, MMT.REVISION REVISION
, MMT.SUBINVENTORY_CODE SUBINVENTORY
, MMT.LOCATOR_ID LOCATOR_ID
, MTLN.LOT_NUMBER LOT_NUMBER
, MUT.SERIAL_NUMBER SERIAL_NUMBER
, MTLN.TRANSACTION_QUANTITY SHIPPED_QUANTITY
, MMT.TRANSACTION_UOM TRANSACTION_UOM
, MMT.TRANSACTION_DATE TRANSACTION_DATE
, MSI.RESERVABLE_TYPE RESERVABLE_TYPE
, HAOU.LOCATION_ID HR_LOCATION_ID
, MSEI.LOCATION_ID SUBINV_LOCATION_ID
, CTE.PROCESSED_FLAG PROCESSED_FLAG
, CTE.SRC_LOT_CTRL_CODE SRC_LOT_CTRL_CODE
, CTE.SRC_SERIAL_NUM_CTRL_CODE SRC_SERIAL_NUM_CTRL_CODE
, CTE.SRC_LOCATION_CTRL_CODE SRC_LOCATION_CTRL_CODE
, CTE.SRC_REV_QTY_CTRL_CODE SRC_REV_QTY_CTRL_CODE
, CTE.DST_LOT_CTRL_CODE DST_LOT_CTRL_CODE
, CTE.DST_SERIAL_NUM_CTRL_CODE DST_SERIAL_NUM_CTRL_CODE
, CTE.DST_LOCATION_CTRL_CODE DST_LOCATION_CTRL_CODE
, CTE.DST_REV_QTY_CTRL_CODE DST_REV_QTY_CTRL_CODE
, CTE.COMMS_NL_TRACKABLE_FLAG COMMS_NL_TRACKABLE_FLAG
FROM CSI_TXN_ERRORS CTE
, MTL_SYSTEM_ITEMS MSI
, MTL_UNIT_TRANSACTIONS MUT
, MTL_TRANSACTION_LOT_NUMBERS MTLN
, MTL_MATERIAL_TRANSACTIONS MMT
, MTL_SECONDARY_INVENTORIES MSEI
, HR_ALL_ORGANIZATION_UNITS HAOU
WHERE MMT.TRANSACTION_ID(+) = CTE.INV_MATERIAL_TRANSACTION_ID
AND MMT.TRANSACTION_ID = MTLN.TRANSACTION_ID(+)
AND MTLN.SERIAL_TRANSACTION_ID = MUT.TRANSACTION_ID(+)
AND MSI.ORGANIZATION_ID = MMT.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MMT.INVENTORY_ITEM_ID
AND MSI.LOT_CONTROL_CODE = 2
AND MMT.ORGANIZATION_ID = HAOU.ORGANIZATION_ID(+)
AND MMT.SUBINVENTORY_CODE = MSEI.SECONDARY_INVENTORY_NAME(+)
AND MMT.ORGANIZATION_ID = MSEI.ORGANIZATION_ID(+)

Columns