VIEW: APPS.WIPBV_WIP_TXN_ALLOCATIONS

Source

View Text - Preformatted

SELECT ta.transaction_quantity , ta.primary_quantity , 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 , wip_txn_allocations ta WHERE 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

View Text - HTML Formatted

SELECT TA.TRANSACTION_QUANTITY
, TA.PRIMARY_QUANTITY
, 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
, WIP_TXN_ALLOCATIONS TA
WHERE 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