DBA Data[Home] [Help]

APPS.WSM_SERIAL_SUPPORT_GRP dependencies on WIP_MOVE_TRANSACTIONS

Line 354: from wip_move_transactions wmt

350:
351: --Bug 5215899: Handle null value for batch_id.
352: select max(wmt.transaction_id)
353: into l_move_txn_id
354: from wip_move_transactions wmt
355: where wmt.organization_id = p_organization_id
356: and wmt.wip_entity_id = p_wip_entity_id
357: and wmt.wsm_undo_txn_id IS NULL
358: and wmt.transaction_id = nvl(wmt.batch_id,wmt.transaction_id)

Line 364: from wip_move_transactions wmt

360:
361: begin
362: select wmt.transaction_id
363: into l_scrap_txn_id
364: from wip_move_transactions wmt
365: where wmt.organization_id = p_organization_id
366: and wmt.wip_entity_id = p_wip_entity_id
367: and wmt.wsm_undo_txn_id IS NULL
368: and wmt.transaction_id <> p_move_txn_id