VIEW: APPS.WIPBV_MFG_TRANSACTIONS

Source

View Text - Preformatted

SELECT /* REGULAR ATTRIBUTES */ TR.TRANSACTION_ID , '_LA:transaction_type:MFG_LOOKUPS:WIP_TRANSACTION_TYPE:MEANING' , TR.TRANSACTION_DATE , TR.SOURCE_CODE , TR.OPERATION_SEQ_NUM , TR.RESOURCE_SEQ_NUM , '_LA:autocharge_type:MFG_LOOKUPS:BOM_AUTOCHARGE_TYPE:MEANING' , TR.USAGE_RATE_OR_AMOUNT , '_LA:basis_type:MFG_LOOKUPS:CST_BASIS:MEANING' , TR.TRANSACTION_QUANTITY , TR.TRANSACTION_UOM , TR.PRIMARY_QUANTITY , TR.PRIMARY_UOM , TR.ACTUAL_RESOURCE_RATE , TR.STANDARD_RESOURCE_RATE , TR.CURRENCY_CODE , TR.CURRENCY_CONVERSION_DATE , TR.CURRENCY_CONVERSION_RATE , TR.CURRENCY_CONVERSION_TYPE , TR.CURRENCY_ACTUAL_RESOURCE_RATE , 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.EMPLOYEE_ID , TR.RESOURCE_ID , TR.ACTIVITY_ID , TR.REASON_ID , TR.MOVE_TRANSACTION_ID , TR.COMPLETION_TRANSACTION_ID , TR.PROJECT_ID , TR.TASK_ID , TR.PO_HEADER_ID , TR.PO_LINE_ID , TR.RCV_TRANSACTION_ID , TR.COST_UPDATE_ID /* WHO */ , TR.CREATION_DATE , TR.CREATED_BY , TR.LAST_UPDATE_DATE , TR.LAST_UPDATED_BY FROM WIP_TRANSACTIONS TR WHERE '_SEC:tr.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT /* REGULAR ATTRIBUTES */ TR.TRANSACTION_ID
, '_LA:TRANSACTION_TYPE:MFG_LOOKUPS:WIP_TRANSACTION_TYPE:MEANING'
, TR.TRANSACTION_DATE
, TR.SOURCE_CODE
, TR.OPERATION_SEQ_NUM
, TR.RESOURCE_SEQ_NUM
, '_LA:AUTOCHARGE_TYPE:MFG_LOOKUPS:BOM_AUTOCHARGE_TYPE:MEANING'
, TR.USAGE_RATE_OR_AMOUNT
, '_LA:BASIS_TYPE:MFG_LOOKUPS:CST_BASIS:MEANING'
, TR.TRANSACTION_QUANTITY
, TR.TRANSACTION_UOM
, TR.PRIMARY_QUANTITY
, TR.PRIMARY_UOM
, TR.ACTUAL_RESOURCE_RATE
, TR.STANDARD_RESOURCE_RATE
, TR.CURRENCY_CODE
, TR.CURRENCY_CONVERSION_DATE
, TR.CURRENCY_CONVERSION_RATE
, TR.CURRENCY_CONVERSION_TYPE
, TR.CURRENCY_ACTUAL_RESOURCE_RATE
, 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.EMPLOYEE_ID
, TR.RESOURCE_ID
, TR.ACTIVITY_ID
, TR.REASON_ID
, TR.MOVE_TRANSACTION_ID
, TR.COMPLETION_TRANSACTION_ID
, TR.PROJECT_ID
, TR.TASK_ID
, TR.PO_HEADER_ID
, TR.PO_LINE_ID
, TR.RCV_TRANSACTION_ID
, TR.COST_UPDATE_ID /* WHO */
, TR.CREATION_DATE
, TR.CREATED_BY
, TR.LAST_UPDATE_DATE
, TR.LAST_UPDATED_BY
FROM WIP_TRANSACTIONS TR
WHERE '_SEC:TR.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY