View: WIPFV_WIP_TXN_ALLOCATIONS

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

View Text

SELECT TA.TRANSACTION_QUANTITY
, TA.PRIMARY_QUANTITY
, PA.ORGANIZATION_CODE
, AL.NAME
, TA.TRANSACTION_ID
, TA.REPETITIVE_SCHEDULE_ID
, TA.ORGANIZATION_ID
, TA.CREATION_DATE
, TA.CREATED_BY
, TA.LAST_UPDATE_DATE
, TA.LAST_UPDATED_BY
FROM WIP_TRANSACTIONS WT
, WIP_REPETITIVE_SCHEDULES RS
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, WIP_TXN_ALLOCATIONS TA
WHERE TA.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND TA.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND TA.REPETITIVE_SCHEDULE_ID = RS.REPETITIVE_SCHEDULE_ID
AND TA.TRANSACTION_ID = WT.TRANSACTION_ID
AND '_SEC:TA.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns