VIEW: APPS.WIPBV_OVERHEAD_MFG_TXNS

Source

View Text - Preformatted

SELECT /* REGULAR ATTRIBUTES */ TR.TRANSACTION_ID , '_LA:tr.transaction_type:MFG_LOOKUPS:WIP_TRANSACTION_TYPE:MEANING' , TR.TRANSACTION_DATE , TR.SOURCE_CODE , TR.OPERATION_SEQ_NUM , '_LA:tr.autocharge_type:MFG_LOOKUPS:BOM_AUTOCHARGE_TYPE:MEANING' , '_LA:tr.basis_type:MFG_LOOKUPS:CST_BASIS:MEANING' , TR.TRANSACTION_QUANTITY , TR.TRANSACTION_UOM , TR.PRIMARY_QUANTITY , TR.PRIMARY_UOM , TR.CURRENCY_CODE , TR.CURRENCY_CONVERSION_DATE , TR.CURRENCY_CONVERSION_RATE , TR.CURRENCY_CONVERSION_TYPE , TR.REFERENCE /* IDS */ , TR.ORGANIZATION_ID , TR.WIP_ENTITY_ID , TR.PRIMARY_ITEM_ID , TR.ACCT_PERIOD_ID , TR.DEPARTMENT_ID , TR.LINE_ID , TR.REASON_ID , TR.MOVE_TRANSACTION_ID , TR.COMPLETION_TRANSACTION_ID , TR.PROJECT_ID , TR.TASK_ID /* WHO */ , TR.CREATION_DATE , TR.CREATED_BY , TR.LAST_UPDATE_DATE , TR.LAST_UPDATED_BY FROM WIP_TRANSACTIONS TR WHERE TR.TRANSACTION_TYPE = 2 AND '_SEC:tr.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT /* REGULAR ATTRIBUTES */ TR.TRANSACTION_ID
, '_LA:TR.TRANSACTION_TYPE:MFG_LOOKUPS:WIP_TRANSACTION_TYPE:MEANING'
, TR.TRANSACTION_DATE
, TR.SOURCE_CODE
, TR.OPERATION_SEQ_NUM
, '_LA:TR.AUTOCHARGE_TYPE:MFG_LOOKUPS:BOM_AUTOCHARGE_TYPE:MEANING'
, '_LA:TR.BASIS_TYPE:MFG_LOOKUPS:CST_BASIS:MEANING'
, TR.TRANSACTION_QUANTITY
, TR.TRANSACTION_UOM
, TR.PRIMARY_QUANTITY
, TR.PRIMARY_UOM
, TR.CURRENCY_CODE
, TR.CURRENCY_CONVERSION_DATE
, TR.CURRENCY_CONVERSION_RATE
, TR.CURRENCY_CONVERSION_TYPE
, TR.REFERENCE /* IDS */
, TR.ORGANIZATION_ID
, TR.WIP_ENTITY_ID
, TR.PRIMARY_ITEM_ID
, TR.ACCT_PERIOD_ID
, TR.DEPARTMENT_ID
, TR.LINE_ID
, TR.REASON_ID
, TR.MOVE_TRANSACTION_ID
, TR.COMPLETION_TRANSACTION_ID
, TR.PROJECT_ID
, TR.TASK_ID /* WHO */
, TR.CREATION_DATE
, TR.CREATED_BY
, TR.LAST_UPDATE_DATE
, TR.LAST_UPDATED_BY
FROM WIP_TRANSACTIONS TR
WHERE TR.TRANSACTION_TYPE = 2
AND '_SEC:TR.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY