eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_PICKING_PVT dependencies on MTL_TXN_REQUEST_HEADERS

Line 111: from mtl_txn_request_headers mtrh

107: and mtrl.inventory_item_id = wro.inventory_item_id
108: and mtrl.organization_id = wro.organization_id
109: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED
110: and exists(select 1
111: from mtl_txn_request_headers mtrh
112: where mtrl.header_id = mtrh.header_id
113: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK
114: and rownum = 1)
115:

Line 132: from mtl_txn_request_headers mtrh

128: and mtrl.txn_source_id = we.wip_entity_id
129: and mtrl.txn_source_line_id = wro.operation_seq_num
130: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED
131: and exists(select 1
132: from mtl_txn_request_headers mtrh
133: where mtrl.header_id = mtrh.header_id
134: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK
135: and rownum = 1)
136:

Line 150: from mtl_txn_request_headers mtrh

146: and mtrl.txn_source_id = we.wip_entity_id
147: and mtrl.organization_id = we.organization_id
148: and we.wip_entity_id = p_wip_entity_id
149: and exists(select 1
150: from mtl_txn_request_headers mtrh
151: where mtrl.header_id = mtrh.header_id
152: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK);
153:
154: BEGIN

Line 286: from mtl_txn_request_headers mtrh

282: and mtrl.inventory_item_id = wro.inventory_item_id
283: and mtrl.organization_id = wro.organization_id
284: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED
285: and exists(select 1
286: from mtl_txn_request_headers mtrh
287: where mtrl.header_id = mtrh.header_id
288: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK)
289:
290: for update of wro.quantity_allocated, quantity_backordered nowait;

Line 304: from mtl_txn_request_headers mtrh

300: and mtrl.inventory_item_id = wro.inventory_item_id
301: and mtrl.organization_id = wro.organization_id
302: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED
303: and exists(select 1
304: from mtl_txn_request_headers mtrh
305: where mtrl.header_id = mtrh.header_id
306: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK)
307:
308: for update of wro.quantity_allocated, quantity_backordered nowait;

Line 449: from mtl_txn_request_headers mtrh

445: and mtrl.inventory_item_id = wro.inventory_item_id
446: and mtrl.organization_id = wro.organization_id
447: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED
448: and exists(select 1
449: from mtl_txn_request_headers mtrh
450: where mtrl.header_id = mtrh.header_id
451: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK)
452:
453: order by mtrl.creation_date desc /* Traverse thru move orders in LIFO fashion */

Line 469: from mtl_txn_request_headers mtrh

465: and mtrl.inventory_item_id = wro.inventory_item_id
466: and mtrl.organization_id = wro.organization_id
467: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED
468: and exists(select 1
469: from mtl_txn_request_headers mtrh
470: where mtrl.header_id = mtrh.header_id
471: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK)
472:
473: order by mtrl.creation_date desc /* Traverse thru move orders in LIFO fashion */

Line 596: from mtl_txn_request_headers mtrh

592: and mtrl.inventory_item_id = wro.inventory_item_id
593: and mtrl.organization_id = wro.organization_id
594: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED
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

Line 618: from mtl_txn_request_headers mtrh

614: and mtrl.inventory_item_id = wro.inventory_item_id
615: and mtrl.organization_id = wro.organization_id
616: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED
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