VIEW: APPS.MTL_TRANSACTIONS_INTERFACE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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