[Home] [Help]
8191: msn.inventory_item_id,
8192: msn.current_organization_id,
8193: wmt.wip_entity_id
8194: from mtl_serial_numbers msn,
8195: wip_move_transactions wmt,
8196: wsm_lot_move_txn_interface wlmti,
8197: wsm_lot_based_jobs wlbj
8198: where wlmti.group_id = p_group_id
8199: and wlmti.internal_group_id = p_internal_group_id
8236: msn.inventory_item_id,
8237: msn.current_organization_id,
8238: wmt.wip_entity_id
8239: from mtl_serial_numbers msn,
8240: wip_move_transactions wmt,
8241: wsm_lot_based_jobs wlbj
8242: where wmt.transaction_id in (p_move_txn_id, p_scrap_txn_id)
8243: and wmt.wip_entity_id = wlbj.wip_entity_id
8244: and wlbj.first_serial_txn_id IS NULL
8253: msn.inventory_item_id,
8254: msn.current_organization_id,
8255: wmt.wip_entity_id
8256: from mtl_serial_numbers msn,
8257: wip_move_transactions wmt,
8258: wip_serial_move_transactions wsmt,
8259: wsm_lot_based_jobs wlbj
8260: where wmt.transaction_id in (p_move_txn_id, p_scrap_txn_id)
8261: and wmt.wip_entity_id = wlbj.wip_entity_id
8353: attribute14 ,
8354: attribute15
8355: from wsm_serial_txn_interface wsti
8356: where header_id IN (Select wmt.transaction_id
8357: from wip_move_transactions wmt,
8358: wsm_lot_move_txn_interface wlmti
8359: where wlmti.group_id = p_group_id
8360: and wlmti.internal_group_id = p_internal_group_id
8361: and wlmti.wip_entity_id = wmt.wip_entity_id
9168: END IF;
9169: ELSE
9170: select max(wmt.transaction_id)
9171: into l_old_move_txn_id
9172: from wip_move_transactions wmt
9173: where wmt.organization_id = p_organization_id
9174: and wmt.wip_entity_id = p_wip_entity_id
9175: and wmt.wsm_undo_txn_id IS NULL
9176: and wmt.transaction_id = wmt.batch_id;
9177:
9178: BEGIN
9179: select max(transaction_id)
9180: into l_old_scrap_txn_id
9181: from wip_move_transactions
9182: where organization_id = p_organization_id
9183: and wip_entity_id = p_wip_entity_id
9184: and batch_id = l_old_move_txn_id
9185: and transaction_id <> batch_id;