DBA Data[Home] [Help]

APPS.WSM_MES_UTILITIES_PVT dependencies on WIP_MOVE_TRANSACTIONS

Line 359: from wip_move_transactions

355:
356: l_txn_id := NULL;
357: select max(transaction_id)
358: into l_txn_id
359: from wip_move_transactions
360: where organization_id = p_org_id
361: and wip_entity_id = p_wip_entity_id
362: and wsm_undo_txn_id IS NULL;
363:

Line 371: from wip_move_transactions

367: return;
368: else
369: select source_code
370: into l_undo_source_code
371: from wip_move_transactions
372: where transaction_id = l_txn_id;
373: end if;
374:
375: if ((l_undo_source_code IS NULL) OR

Line 408: from wip_move_transactions

404:
405: begin
406: select max(transaction_date)
407: into l_max_move_txn_date
408: from wip_move_transactions
409: where organization_id = p_org_id
410: and wip_entity_id = p_wip_entity_id
411: and wsm_undo_txn_id IS NULL;
412: exception