View: WIPBV_OSP_MFG_TXNS

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

View Text

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
, TR.RESOURCE_SEQ_NUM
, '_LA:TR.AUTOCHARGE_TYPE:MFG_LOOKUPS:BOM_AUTOCHARGE_TYPE:MEANING'
, TR.USAGE_RATE_OR_AMOUNT
, '_LA:TR.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.RESOURCE_ID
, TR.ACTIVITY_ID
, TR.REASON_ID
, TR.PROJECT_ID
, TR.TASK_ID
, TR.PO_HEADER_ID
, TR.PO_LINE_ID
, TR.RCV_TRANSACTION_ID /* WHO */
, TR.CREATION_DATE
, TR.CREATED_BY
, TR.LAST_UPDATE_DATE
, TR.LAST_UPDATED_BY
FROM WIP_TRANSACTIONS TR
WHERE TR.TRANSACTION_TYPE = 3
AND '_SEC:TR.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns