APPS.WIP_PICKING_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 599: and not exists (select 1 from mtl_material_transactions_temp mmtt --Bug#16041371:Check if there are any pending transactions in MMTT

595: and exists(select 1
596: from mtl_txn_request_headers mtrh
597: where mtrl.header_id = mtrh.header_id
598: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK)
599: and not exists (select 1 from mtl_material_transactions_temp mmtt --Bug#16041371:Check if there are any pending transactions in MMTT
600: where transaction_source_id=p_wip_entity_id and mmtt.organization_id=wro.organization_id and mmtt.repetitive_line_id=p_repetitive_schedule_id and
601: mmtt.operation_seq_num in (-1,1) and mmtt.inventory_item_id=wro.inventory_item_id AND mmtt.transaction_source_type_id=INV_Globals.G_SOURCETYPE_WIP)
602: for update of wro.quantity_allocated, wro.quantity_backordered nowait; --make sure no orders are transacted in the meantime
603:

Line 621: and not exists (select 1 from mtl_material_transactions_temp mmtt --Bug#16041371:Check if there are any pending transactions in MMTT

617: and exists(select 1
618: from mtl_txn_request_headers mtrh
619: where mtrl.header_id = mtrh.header_id
620: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK)
621: and not exists (select 1 from mtl_material_transactions_temp mmtt --Bug#16041371:Check if there are any pending transactions in MMTT
622: where mmtt.transaction_source_id=p_wip_entity_id and mmtt.transaction_source_type_id=INV_Globals.G_SOURCETYPE_WIP and mmtt.organization_id=wro.organization_id
623: and mmtt.operation_seq_num in (-1,1) and mmtt.inventory_item_id=wro.inventory_item_id)
624: for update of wro.quantity_allocated, wro.quantity_backordered nowait;--make sure no orders are transacted in the meantime
625: