DBA Data[Home] [Help]

APPS.WIP_PICKING_PVT dependencies on MTL_TXN_REQUEST_HEADERS

Line 109: from mtl_txn_request_headers mtrh

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

Line 130: from mtl_txn_request_headers mtrh

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

Line 148: from mtl_txn_request_headers mtrh

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

Line 272: from mtl_txn_request_headers mtrh

268: and mtrl.inventory_item_id = wro.inventory_item_id
269: and mtrl.organization_id = wro.organization_id
270: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED
271: and exists(select 1
272: from mtl_txn_request_headers mtrh
273: where mtrl.header_id = mtrh.header_id
274: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK)
275:
276: for update of wro.quantity_allocated, quantity_backordered nowait;

Line 290: from mtl_txn_request_headers mtrh

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

Line 435: from mtl_txn_request_headers mtrh

431: and mtrl.inventory_item_id = wro.inventory_item_id
432: and mtrl.organization_id = wro.organization_id
433: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED
434: and exists(select 1
435: from mtl_txn_request_headers mtrh
436: where mtrl.header_id = mtrh.header_id
437: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK)
438:
439: order by mtrl.creation_date desc /* Traverse thru move orders in LIFO fashion */

Line 455: from mtl_txn_request_headers mtrh

451: and mtrl.inventory_item_id = wro.inventory_item_id
452: and mtrl.organization_id = wro.organization_id
453: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED
454: and exists(select 1
455: from mtl_txn_request_headers mtrh
456: where mtrl.header_id = mtrh.header_id
457: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK)
458:
459: order by mtrl.creation_date desc /* Traverse thru move orders in LIFO fashion */

Line 582: from mtl_txn_request_headers mtrh

578: and mtrl.inventory_item_id = wro.inventory_item_id
579: and mtrl.organization_id = wro.organization_id
580: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED
581: and exists(select 1
582: from mtl_txn_request_headers mtrh
583: where mtrl.header_id = mtrh.header_id
584: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK)
585:
586: for update of wro.quantity_allocated, wro.quantity_backordered nowait; --make sure no orders are transacted in the meantime

Line 599: from mtl_txn_request_headers mtrh

595: and mtrl.inventory_item_id = wro.inventory_item_id
596: and mtrl.organization_id = wro.organization_id
597: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED
598: and exists(select 1
599: from mtl_txn_request_headers mtrh
600: where mtrl.header_id = mtrh.header_id
601: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK)
602: for update of wro.quantity_allocated, wro.quantity_backordered nowait;--make sure no orders are transacted in the meantime
603: