VIEW: APPS.WIPFV_WIP_MOVE_TRANSACTIONS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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