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 INV_GLOBALS

Line 109: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED

105: and mtrl.reference_id = wro.repetitive_schedule_id
106: and mtrl.txn_source_line_id = wro.operation_seq_num
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

Line 113: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK

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:
116: for update of wro.quantity_allocated, quantity_backordered nowait;
117:

Line 130: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED

126: and mtrl.organization_id = wro.organization_id
127: and mtrl.inventory_item_id = wro.inventory_item_id
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

Line 134: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK

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:
137: for update of wro.quantity_allocated, quantity_backordered nowait;
138:

Line 144: where mtrl.TRANSACTION_TYPE_ID = INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR -- 51

140:
141: CURSOR c_flowLines IS
142: select line_id
143: from mtl_txn_request_lines mtrl, wip_entities we
144: where mtrl.TRANSACTION_TYPE_ID = INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR -- 51
145: and mtrl.TRANSACTION_SOURCE_TYPE_ID = INV_Globals.G_SOURCETYPE_INVENTORY --13
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

Line 145: and mtrl.TRANSACTION_SOURCE_TYPE_ID = INV_Globals.G_SOURCETYPE_INVENTORY --13

141: CURSOR c_flowLines IS
142: select line_id
143: from mtl_txn_request_lines mtrl, wip_entities we
144: where mtrl.TRANSACTION_TYPE_ID = INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR -- 51
145: and mtrl.TRANSACTION_SOURCE_TYPE_ID = INV_Globals.G_SOURCETYPE_INVENTORY --13
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

Line 152: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK);

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
155: if(p_wip_entity_type not in (wip_constants.discrete,
156: wip_constants.lotbased,

Line 284: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED

280: and mtrl.txn_source_line_id = wro.operation_seq_num
281: and wro.inventory_item_id = p_inventory_item_id
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)

Line 288: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK)

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;
291:
292: CURSOR c_discLines IS

Line 302: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED

298: and mtrl.txn_source_line_id = wro.operation_seq_num
299: and wro.inventory_item_id = p_inventory_item_id
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)

Line 306: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK)

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;
309:
310:

Line 447: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED

443: and mtrl.txn_source_line_id = wro.operation_seq_num
444: and wro.inventory_item_id = v_inventory_item_id
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)

Line 451: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK)

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 */
454:
455: for update of wro.quantity_allocated, quantity_backordered nowait;

Line 467: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED

463: and mtrl.txn_source_line_id = wro.operation_seq_num
464: and wro.inventory_item_id = v_inventory_item_id
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)

Line 471: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK)

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 */
474: for update of wro.quantity_allocated, quantity_backordered nowait;
475:

Line 594: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED

590: and wro.operation_seq_num = 1
591: and mtrl.txn_source_line_id = wro.operation_seq_num
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)

Line 598: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK)

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
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

Line 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)

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:
604: --Bug#16373586: Updating only when no pending transactions exist in MMTT. MTI is not checked here as customers can directly insert into MTI
605: -- Also, the source_type should not be WIP. In case of backflush transfer, the source type is INV.

Line 616: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED

612: and wro.operation_seq_num = 1
613: and mtrl.txn_source_line_id = wro.operation_seq_num
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)

Line 620: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK)

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
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

Line 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

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:
626: l_lineID NUMBER;

Line 1107: l_backflushTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR;

1103:
1104: --The following variables are used for performance reasons in order
1105: --to avoid multiple unnecessary cross package calls when creating lines.
1106: l_sysDate DATE := sysdate;
1107: l_backflushTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR;
1108: l_issueTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE;
1109: l_push NUMBER := wip_constants.push;
1110: /* Bug 4917429 */
1111: l_jobname VARCHAR2(240);

Line 1108: l_issueTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE;

1104: --The following variables are used for performance reasons in order
1105: --to avoid multiple unnecessary cross package calls when creating lines.
1106: l_sysDate DATE := sysdate;
1107: l_backflushTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR;
1108: l_issueTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE;
1109: l_push NUMBER := wip_constants.push;
1110: /* Bug 4917429 */
1111: l_jobname VARCHAR2(240);
1112: l_item VARCHAR2(2000);

Line 1491: l_hdrRec.move_order_type := INV_Globals.G_MOVE_ORDER_MFG_PICK;

1487: wip_logger.log('wip_picking_pvt.allocate => line count passed to inv_wip_picking_pvt.release_pick_batch: '
1488: || l_lineCount || ';total=' || p_alloc_tbl.COUNT, l_dummy2);
1489: end if;
1490: if(l_lineCount > 0) then
1491: l_hdrRec.move_order_type := INV_Globals.G_MOVE_ORDER_MFG_PICK;
1492: inv_wip_picking_pvt.release_pick_batch(p_mo_header_rec => l_hdrRec,
1493: p_mo_line_rec_tbl => l_linesTable,
1494: p_auto_detail_flag => nvl(p_auto_detail_flag,'T'),
1495: p_print_pick_slip => nvl(p_print_pick_slip,'F'),

Line 1682: l_lineStatus NUMBER := INV_Globals.G_TO_STATUS_PREAPPROVED;

1678:
1679: l_sysDate DATE := sysdate;
1680: l_userId NUMBER := fnd_global.user_id;
1681: l_loginId NUMBER := fnd_global.login_id;
1682: l_lineStatus NUMBER := INV_Globals.G_TO_STATUS_PREAPPROVED;
1683: l_push NUMBER := wip_constants.push;
1684: l_pick_grouping_rule_id NUMBER;
1685: l_unit_number VARCHAR2(30);
1686: BEGIN

Line 1697: p_hdrRec.operation := INV_Globals.G_OPR_CREATE;

1693: p_hdrRec.last_updated_by := l_userId;
1694: p_hdrRec.last_update_date := l_sysDate;
1695: p_hdrRec.last_update_login := l_loginId;
1696: p_hdrRec.organization_id := p_organization_id;
1697: p_hdrRec.operation := INV_Globals.G_OPR_CREATE;
1698: p_hdrRec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
1699: p_linesRec.created_by := l_userId;
1700: p_linesRec.creation_date := l_sysDate;
1701: p_linesRec.last_updated_by := l_userId;

Line 1698: p_hdrRec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;

1694: p_hdrRec.last_update_date := l_sysDate;
1695: p_hdrRec.last_update_login := l_loginId;
1696: p_hdrRec.organization_id := p_organization_id;
1697: p_hdrRec.operation := INV_Globals.G_OPR_CREATE;
1698: p_hdrRec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
1699: p_linesRec.created_by := l_userId;
1700: p_linesRec.creation_date := l_sysDate;
1701: p_linesRec.last_updated_by := l_userId;
1702: p_linesRec.last_update_date := l_sysDate;

Line 1706: p_linesRec.operation := INV_Globals.G_OPR_CREATE;

1702: p_linesRec.last_update_date := l_sysDate;
1703: p_linesRec.last_update_login := l_loginId;
1704: p_linesRec.organization_id := p_organization_id;
1705: p_linesRec.line_status := l_lineStatus;
1706: p_linesRec.operation := INV_Globals.G_OPR_CREATE;
1707:
1708: /* for EAM entity type, select picksilp grouping rule from wip_parameters. If no rule is defined, raise an exception with suitable message */
1709: if(p_wip_entity_type = wip_constants.eam) then
1710:

Line 1853: l_backflushTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR;

1849: l_lotbased NUMBER := wip_constants.lotbased;
1850: l_repetitive NUMBER := wip_constants.repetitive;
1851: l_msgCount NUMBER;
1852: l_revControlCode VARCHAR2(3);
1853: l_backflushTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR;
1854: l_issueTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE;
1855: l_push NUMBER := wip_constants.push;
1856: l_carton_grouping_id NUMBER;
1857: TYPE carton_tbl_t IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 1854: l_issueTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE;

1850: l_repetitive NUMBER := wip_constants.repetitive;
1851: l_msgCount NUMBER;
1852: l_revControlCode VARCHAR2(3);
1853: l_backflushTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR;
1854: l_issueTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE;
1855: l_push NUMBER := wip_constants.push;
1856: l_carton_grouping_id NUMBER;
1857: TYPE carton_tbl_t IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1858: carton_tbl carton_tbl_t;

Line 2117: l_hdrRec.move_order_type := INV_Globals.G_MOVE_ORDER_MFG_PICK;

2113: l_pickSetId := l_pickSetId + 1; --increment regardless
2114: end loop;
2115:
2116: if(l_lineCount > 0) then
2117: l_hdrRec.move_order_type := INV_Globals.G_MOVE_ORDER_MFG_PICK;
2118: inv_wip_picking_pvt.release_pick_batch(p_mo_header_rec => l_hdrRec,
2119: p_mo_line_rec_tbl => l_linesTable,
2120: p_auto_detail_flag => nvl(p_auto_detail_flag,'T'),
2121: p_print_pick_slip => nvl(p_print_pick_slip,'F'),