View: WIPFV_WIP_MOVE_TRANSACTIONS

Product:	WIP - Work in Process
Description:
Implementation/DBA Data:	APPS.WIPFV_WIP_MOVE_TRANSACTIONS

View Text

SELECT MO.TRANSACTION_DATE
, MO.GROUP_ID
, MO.FM_INTRAOPERATION_STEP_TYPE
, MO.TO_INTRAOPERATION_STEP_TYPE
, MO.TRANSACTION_QUANTITY
, MO.REFERENCE
, MO.PRIMARY_QUANTITY
, MO.OVERCOMPLETION_TRANSACTION_QTY
, MO.OVERCOMPLETION_PRIMARY_QTY
, DE1.DEPARTMENT_CODE
, DE2.DEPARTMENT_CODE
, PA.ORGANIZATION_CODE
, AL.NAME
, EN.WIP_ENTITY_NAME
, LI.LINE_CODE
, '_KF:INV:MSTK:SY'
, AC.PERIOD_NAME
, MO.FM_OPERATION_CODE
, MO.TO_OPERATION_CODE
, UN1.UNIT_OF_MEASURE
, UN2.UNIT_OF_MEASURE
, '_KF:SQLGL:GL#:CO'
, PL.NAME
, TR.REASON_NAME
, '_DF:WIP:WIP_MOVE_TRANSACTIONS:MO'
, MO.TRANSACTION_ID
, MO.FM_DEPARTMENT_ID
, MO.TO_DEPARTMENT_ID
, MO.ORGANIZATION_ID
, MO.WIP_ENTITY_ID
, MO.LINE_ID
, MO.PRIMARY_ITEM_ID
, MO.ACCT_PERIOD_ID
, MO.FM_OPERATION_SEQ_NUM
, MO.TO_OPERATION_SEQ_NUM
, MO.TRANSACTION_UOM
, MO.PRIMARY_UOM
, MO.SCRAP_ACCOUNT_ID
, MO.QA_COLLECTION_ID
, MO.REASON_ID
, MO.OVERCOMPLETION_TRANSACTION_ID
, MO.CREATION_DATE
, MO.CREATED_BY
, MO.LAST_UPDATE_DATE
, MO.LAST_UPDATED_BY
FROM MTL_SYSTEM_ITEMS SY
, QA_PLANS PL
, QA_RESULTS RE
, GL_CODE_COMBINATIONS CO
, MTL_TRANSACTION_REASONS TR
, WIP_LINES LI
, MTL_UNITS_OF_MEASURE UN1
, MTL_UNITS_OF_MEASURE UN2
, WIP_ENTITIES EN
, ORG_ACCT_PERIODS AC
, BOM_DEPARTMENTS DE1
, BOM_DEPARTMENTS DE2
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, WIP_MOVE_TRANSACTIONS MO
WHERE MO.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND MO.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND MO.FM_DEPARTMENT_ID = DE1.DEPARTMENT_ID
AND MO.TO_DEPARTMENT_ID = DE2.DEPARTMENT_ID
AND MO.ACCT_PERIOD_ID = AC.ACCT_PERIOD_ID
AND MO.ORGANIZATION_ID = AC.ORGANIZATION_ID
AND MO.WIP_ENTITY_ID = EN.WIP_ENTITY_ID
AND MO.TRANSACTION_UOM = UN1.UOM_CODE
AND MO.PRIMARY_UOM = UN2.UOM_CODE
AND MO.LINE_ID = LI.LINE_ID(+)
AND MO.ORGANIZATION_ID = LI.ORGANIZATION_ID(+)
AND MO.REASON_ID = TR.REASON_ID(+)
AND MO.SCRAP_ACCOUNT_ID = CO.CODE_COMBINATION_ID(+)
AND MO.QA_COLLECTION_ID = RE.COLLECTION_ID(+)
AND MO.ORGANIZATION_ID = RE.ORGANIZATION_ID(+)
AND RE.PLAN_ID = PL.PLAN_ID(+)
AND RE.ORGANIZATION_ID = PL.ORGANIZATION_ID(+)
AND MO.PRIMARY_ITEM_ID = SY.INVENTORY_ITEM_ID(+)
AND MO.ORGANIZATION_ID = SY.ORGANIZATION_ID(+)
AND '_SEC:MO.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns