View: MTL_TRANSACTIONS_INTERFACE_V

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.MTL_TRANSACTIONS_INTERFACE_V

View Text

SELECT A.ROWID ROW_ID
, A.TRANSACTION_INTERFACE_ID
, A.TRANSACTION_HEADER_ID
, A.SOURCE_CODE
, A.SOURCE_LINE_ID
, A.SOURCE_HEADER_ID
, A.PROCESS_FLAG
, I.MEANING PROCESS_FLAG_DESC
, A.VALIDATION_REQUIRED
, A.TRANSACTION_MODE
, J.MEANING TRANSACTION_MODE_DESC
, A.LOCK_FLAG
, K.MEANING LOCK_FLAG_DESC
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.REQUEST_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_UPDATE_DATE
, A.INVENTORY_ITEM_ID
, MSI.DESCRIPTION ITEM_DESCRIPTION
, MSI.PRIMARY_UOM_CODE
, A.ITEM_SEGMENT1
, A.ITEM_SEGMENT2
, A.ITEM_SEGMENT3
, A.ITEM_SEGMENT4
, A.ITEM_SEGMENT5
, A.ITEM_SEGMENT6
, A.ITEM_SEGMENT7
, A.ITEM_SEGMENT8
, A.ITEM_SEGMENT9
, A.ITEM_SEGMENT10
, A.ITEM_SEGMENT11
, A.ITEM_SEGMENT12
, A.ITEM_SEGMENT13
, A.ITEM_SEGMENT14
, A.ITEM_SEGMENT15
, A.ITEM_SEGMENT16
, A.ITEM_SEGMENT17
, A.ITEM_SEGMENT18
, A.ITEM_SEGMENT19
, A.ITEM_SEGMENT20
, A.REVISION
, A.ORGANIZATION_ID
, MP1.ORGANIZATION_CODE
, HOUT1.NAME ORGANIZATION_NAME
, A.TRANSACTION_QUANTITY
, A.PRIMARY_QUANTITY
, A.TRANSACTION_UOM
, A.TRANSACTION_DATE
, A.ACCT_PERIOD_ID
, A.SUBINVENTORY_CODE
, A.LOCATOR_ID
, A.LOC_SEGMENT1
, A.LOC_SEGMENT2
, A.LOC_SEGMENT3
, A.LOC_SEGMENT4
, A.LOC_SEGMENT5
, A.LOC_SEGMENT6
, A.LOC_SEGMENT7
, A.LOC_SEGMENT8
, A.LOC_SEGMENT9
, A.LOC_SEGMENT10
, A.LOC_SEGMENT11
, A.LOC_SEGMENT12
, A.LOC_SEGMENT13
, A.LOC_SEGMENT14
, A.LOC_SEGMENT15
, A.LOC_SEGMENT16
, A.LOC_SEGMENT17
, A.LOC_SEGMENT18
, A.LOC_SEGMENT19
, A.LOC_SEGMENT20
, A.TRANSACTION_SOURCE_ID
, A.DSP_SEGMENT1
, A.DSP_SEGMENT2
, A.DSP_SEGMENT3
, A.DSP_SEGMENT4
, A.DSP_SEGMENT5
, A.DSP_SEGMENT6
, A.DSP_SEGMENT7
, A.DSP_SEGMENT8
, A.DSP_SEGMENT9
, A.DSP_SEGMENT10
, A.DSP_SEGMENT11
, A.DSP_SEGMENT12
, A.DSP_SEGMENT13
, A.DSP_SEGMENT14
, A.DSP_SEGMENT15
, A.DSP_SEGMENT16
, A.DSP_SEGMENT17
, A.DSP_SEGMENT18
, A.DSP_SEGMENT19
, A.DSP_SEGMENT20
, A.DSP_SEGMENT21
, A.DSP_SEGMENT22
, A.DSP_SEGMENT23
, A.DSP_SEGMENT24
, A.DSP_SEGMENT25
, A.DSP_SEGMENT26
, A.DSP_SEGMENT27
, A.DSP_SEGMENT28
, A.DSP_SEGMENT29
, A.DSP_SEGMENT30
, A.TRANSACTION_SOURCE_NAME
, A.TRANSACTION_SOURCE_TYPE_ID
, G.TRANSACTION_SOURCE_TYPE_NAME
, A.TRANSACTION_ACTION_ID
, F.MEANING TRANSACTION_ACTION_NAME
, A.TRANSACTION_TYPE_ID
, E.TRANSACTION_TYPE_NAME
, A.REASON_ID
, D.REASON_NAME
, A.TRANSACTION_REFERENCE
, A.TRANSACTION_COST
, A.DISTRIBUTION_ACCOUNT_ID
, A.DST_SEGMENT1
, A.DST_SEGMENT2
, A.DST_SEGMENT3
, A.DST_SEGMENT4
, A.DST_SEGMENT5
, A.DST_SEGMENT6
, A.DST_SEGMENT7
, A.DST_SEGMENT8
, A.DST_SEGMENT9
, A.DST_SEGMENT10
, A.DST_SEGMENT11
, A.DST_SEGMENT12
, A.DST_SEGMENT13
, A.DST_SEGMENT14
, A.DST_SEGMENT15
, A.DST_SEGMENT16
, A.DST_SEGMENT17
, A.DST_SEGMENT18
, A.DST_SEGMENT19
, A.DST_SEGMENT20
, A.DST_SEGMENT21
, A.DST_SEGMENT22
, A.DST_SEGMENT23
, A.DST_SEGMENT24
, A.DST_SEGMENT25
, A.DST_SEGMENT26
, A.DST_SEGMENT27
, A.DST_SEGMENT28
, A.DST_SEGMENT29
, A.DST_SEGMENT30
, A.REQUISITION_LINE_ID
, A.REQUISITION_DISTRIBUTION_ID
, A.CURRENCY_CODE
, A.CURRENCY_CONVERSION_TYPE
, A.CURRENCY_CONVERSION_RATE
, A.USSGL_TRANSACTION_CODE
, A.WIP_ENTITY_TYPE
, A.SCHEDULE_ID
, A.EMPLOYEE_CODE
, A.DEPARTMENT_ID
, H.DEPARTMENT_CODE
, A.SCHEDULE_UPDATE_CODE
, A.SETUP_TEARDOWN_CODE
, A.PRIMARY_SWITCH
, A.MRP_CODE
, A.OPERATION_SEQ_NUM
, A.REPETITIVE_LINE_ID
, A.PICKING_LINE_ID
, A.TRX_SOURCE_LINE_ID
, A.TRX_SOURCE_DELIVERY_ID
, A.DEMAND_ID
, A.CUSTOMER_SHIP_ID
, A.LINE_ITEM_NUM
, A.RECEIVING_DOCUMENT
, A.RCV_TRANSACTION_ID
, A.SHIP_TO_LOCATION_ID
, A.ENCUMBRANCE_ACCOUNT
, A.ENCUMBRANCE_AMOUNT
, A.VENDOR_LOT_NUMBER
, A.TRANSFER_SUBINVENTORY
, A.TRANSFER_ORGANIZATION
, MP2.ORGANIZATION_CODE TRANSFER_ORGANIZATION_CODE
, HOUT2.NAME TRANSFER_ORGANIZATION_NAME
, A.TRANSFER_LOCATOR
, A.XFER_LOC_SEGMENT1
, A.XFER_LOC_SEGMENT2
, A.XFER_LOC_SEGMENT3
, A.XFER_LOC_SEGMENT4
, A.XFER_LOC_SEGMENT5
, A.XFER_LOC_SEGMENT6
, A.XFER_LOC_SEGMENT7
, A.XFER_LOC_SEGMENT8
, A.XFER_LOC_SEGMENT9
, A.XFER_LOC_SEGMENT10
, A.XFER_LOC_SEGMENT11
, A.XFER_LOC_SEGMENT12
, A.XFER_LOC_SEGMENT13
, A.XFER_LOC_SEGMENT14
, A.XFER_LOC_SEGMENT15
, A.XFER_LOC_SEGMENT16
, A.XFER_LOC_SEGMENT17
, A.XFER_LOC_SEGMENT18
, A.XFER_LOC_SEGMENT19
, A.XFER_LOC_SEGMENT20
, A.SHIPMENT_NUMBER
, A.TRANSPORTATION_COST
, A.TRANSPORTATION_ACCOUNT
, A.TRANSFER_COST
, A.FREIGHT_CODE
, A.CONTAINERS
, A.WAYBILL_AIRBILL
, A.EXPECTED_ARRIVAL_DATE
, A.NEW_AVERAGE_COST
, A.VALUE_CHANGE
, A.PERCENTAGE_CHANGE
, A.DEMAND_SOURCE_HEADER_ID
, A.DEMAND_SOURCE_LINE
, A.DEMAND_SOURCE_DELIVERY
, A.NEGATIVE_REQ_FLAG
, A.ERROR_EXPLANATION
, A.ERROR_CODE
, A.REQUIRED_FLAG
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.CURRENCY_CONVERSION_DATE
, A.SHIPPABLE_FLAG
, A.MOVEMENT_ID
, A.RESERVATION_QUANTITY
, A.SHIPPED_QUANTITY
, A.SOURCE_PROJECT_ID
, A.SOURCE_TASK_ID
, A.PROJECT_ID
, A.TO_PROJECT_ID
, A.TASK_ID
, A.TO_TASK_ID
, A.EXPENDITURE_TYPE
, A.PA_EXPENDITURE_ORG_ID
, A.COST_GROUP_ID
, A.MATERIAL_ACCOUNT
, A.TRANSFER_COST_GROUP_ID
, A.LPN_ID
, A.TRANSFER_LPN_ID
, LPN1.LICENSE_PLATE_NUMBER LPN
, LPN2.LICENSE_PLATE_NUMBER TRANSFER_LPN
, CG.COST_GROUP COST_GROUP_NAME
, CG2.COST_GROUP TRANSFER_COST_GROUP_NAME
, A.CONTENT_LPN_ID
, LPN3.LICENSE_PLATE_NUMBER CONTENT_LPN
, A.PLANNING_ORGANIZATION_ID
, A.PLANNING_TP_TYPE
, A .OWNING_ORGANIZATION_ID
, A.OWNING_TP_TYPE
, A.SCHEDULE_NUMBER
, A.FLOW_SCHEDULE
, A.SCHEDULED_FLAG
, A.SECONDARY_TRANSACTION_QUANTITY
, A.SECONDARY_UOM_CODE
FROM MTL_SYSTEM_ITEMS MSI
, MTL_PARAMETERS MP1
, HR_ORG_UNITS_NO_JOIN HOUC1
, HR_ALL_ORGANIZATION_UNITS_TL HOUT1
, MTL_PARAMETERS MP2
, HR_ORG_UNITS_NO_JOIN HOUC2
, HR_ALL_ORGANIZATION_UNITS_TL HOUT2
, MTL_TRANSACTION_REASONS D
, MTL_TRANSACTION_TYPES E
, MFG_LOOKUPS F
, MFG_LOOKUPS I
, MFG_LOOKUPS J
, MFG_LOOKUPS K
, MTL_TXN_SOURCE_TYPES G
, BOM_DEPARTMENTS H
, MTL_TRANSACTIONS_INTERFACE A
, CST_COST_GROUPS CG
, CST_COST_GROUPS CG2
, WMS_LICENSE_PLATE_NUMBERS LPN1
, WMS_LICENSE_PLATE_NUMBERS LPN2
, WMS_LICENSE_PLATE_NUMBERS LPN3
WHERE MSI.INVENTORY_ITEM_ID (+) = A.INVENTORY_ITEM_ID
AND HOUC1.ORGANIZATION_ID (+) = A.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID (+) = A.ORGANIZATION_ID
AND MP1.ORGANIZATION_ID (+) = A.ORGANIZATION_ID
AND HOUC1.ORGANIZATION_ID = HOUT1.ORGANIZATION_ID (+)
AND DECODE(HOUT1.ORGANIZATION_ID
, NULL
, '1'
, HOUT1.LANGUAGE) = DECODE(HOUT1.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND MP2.ORGANIZATION_ID (+) = A.TRANSFER_ORGANIZATION
AND HOUC2.ORGANIZATION_ID (+) = A.TRANSFER_ORGANIZATION
AND HOUC2.ORGANIZATION_ID = HOUT2.ORGANIZATION_ID (+)
AND DECODE(HOUT2.ORGANIZATION_ID
, NULL
, '1'
, HOUT2.LANGUAGE) = DECODE(HOUT2.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND D.REASON_ID (+) = A.REASON_ID
AND E.TRANSACTION_TYPE_ID (+) = A.TRANSACTION_TYPE_ID
AND G.TRANSACTION_SOURCE_TYPE_ID (+) = A.TRANSACTION_SOURCE_TYPE_ID
AND A.PROCESS_FLAG != 9
AND H.DEPARTMENT_ID (+) = A.DEPARTMENT_ID
AND H.ORGANIZATION_ID (+) = A.ORGANIZATION_ID
AND F.LOOKUP_TYPE (+) = 'MTL_TRANSACTION_ACTION'
AND F.LOOKUP_CODE (+) = A.TRANSACTION_ACTION_ID
AND I.LOOKUP_TYPE (+) = 'INV_YES_NO_ERROR'
AND I.LOOKUP_CODE (+) = A.PROCESS_FLAG
AND J.LOOKUP_TYPE (+) = 'MTL_TRANSACTION_MODE'
AND J.LOOKUP_CODE (+) = A.TRANSACTION_MODE
AND K.LOOKUP_TYPE (+) = 'SYS_YES_NO'
AND K.LOOKUP_CODE (+) = A.LOCK_FLAG
AND CG.COST_GROUP_ID(+) = A.COST_GROUP_ID
AND CG2.COST_GROUP_ID(+) = A.TRANSFER_COST_GROUP_ID
AND LPN1.LPN_ID(+) = A.LPN_ID
AND LPN2.LPN_ID(+) = A.TRANSFER_LPN_ID
AND LPN3.LPN_ID(+) = A.CONTENT_LPN_ID

Columns