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 107: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED

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

Line 111: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK

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

Line 128: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED

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

Line 132: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK

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

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

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

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

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

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

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

Line 270: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED

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

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

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;
277:
278: CURSOR c_discLines IS

Line 288: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED

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

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

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;
295:
296:

Line 433: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED

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

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

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

Line 453: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED

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

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

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

Line 580: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED

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

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

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
587:
588: CURSOR c_discLines IS

Line 597: and mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED

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

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

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:
604: l_lineID NUMBER;
605: l_msgCount NUMBER;

Line 1082: l_backflushTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR;

1078:
1079: --The following variables are used for performance reasons in order
1080: --to avoid multiple unnecessary cross package calls when creating lines.
1081: l_sysDate DATE := sysdate;
1082: l_backflushTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR;
1083: l_issueTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE;
1084: l_push NUMBER := wip_constants.push;
1085: /* Bug 4917429 */
1086: l_jobname VARCHAR2(240);

Line 1083: l_issueTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE;

1079: --The following variables are used for performance reasons in order
1080: --to avoid multiple unnecessary cross package calls when creating lines.
1081: l_sysDate DATE := sysdate;
1082: l_backflushTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR;
1083: l_issueTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE;
1084: l_push NUMBER := wip_constants.push;
1085: /* Bug 4917429 */
1086: l_jobname VARCHAR2(240);
1087: l_item VARCHAR2(2000);

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

1462: wip_logger.log('wip_picking_pvt.allocate => line count passed to inv_wip_picking_pvt.release_pick_batch: '
1463: || l_lineCount || ';total=' || p_alloc_tbl.COUNT, l_dummy2);
1464: end if;
1465: if(l_lineCount > 0) then
1466: l_hdrRec.move_order_type := INV_Globals.G_MOVE_ORDER_MFG_PICK;
1467: inv_wip_picking_pvt.release_pick_batch(p_mo_header_rec => l_hdrRec,
1468: p_mo_line_rec_tbl => l_linesTable,
1469: p_auto_detail_flag => nvl(p_auto_detail_flag,'T'),
1470: p_print_pick_slip => nvl(p_print_pick_slip,'F'),

Line 1657: l_lineStatus NUMBER := INV_Globals.G_TO_STATUS_PREAPPROVED;

1653:
1654: l_sysDate DATE := sysdate;
1655: l_userId NUMBER := fnd_global.user_id;
1656: l_loginId NUMBER := fnd_global.login_id;
1657: l_lineStatus NUMBER := INV_Globals.G_TO_STATUS_PREAPPROVED;
1658: l_push NUMBER := wip_constants.push;
1659: l_pick_grouping_rule_id NUMBER;
1660:
1661: BEGIN

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

1668: p_hdrRec.last_updated_by := l_userId;
1669: p_hdrRec.last_update_date := l_sysDate;
1670: p_hdrRec.last_update_login := l_loginId;
1671: p_hdrRec.organization_id := p_organization_id;
1672: p_hdrRec.operation := INV_Globals.G_OPR_CREATE;
1673: p_hdrRec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
1674: p_linesRec.created_by := l_userId;
1675: p_linesRec.creation_date := l_sysDate;
1676: p_linesRec.last_updated_by := l_userId;

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

1669: p_hdrRec.last_update_date := l_sysDate;
1670: p_hdrRec.last_update_login := l_loginId;
1671: p_hdrRec.organization_id := p_organization_id;
1672: p_hdrRec.operation := INV_Globals.G_OPR_CREATE;
1673: p_hdrRec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
1674: p_linesRec.created_by := l_userId;
1675: p_linesRec.creation_date := l_sysDate;
1676: p_linesRec.last_updated_by := l_userId;
1677: p_linesRec.last_update_date := l_sysDate;

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

1677: p_linesRec.last_update_date := l_sysDate;
1678: p_linesRec.last_update_login := l_loginId;
1679: p_linesRec.organization_id := p_organization_id;
1680: p_linesRec.line_status := l_lineStatus;
1681: p_linesRec.operation := INV_Globals.G_OPR_CREATE;
1682:
1683: /* for EAM entity type, select picksilp grouping rule from wip_parameters. If no rule is defined, raise an exception with suitable message */
1684: if(p_wip_entity_type = wip_constants.eam) then
1685:

Line 1815: l_backflushTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR;

1811: l_lotbased NUMBER := wip_constants.lotbased;
1812: l_repetitive NUMBER := wip_constants.repetitive;
1813: l_msgCount NUMBER;
1814: l_revControlCode VARCHAR2(3);
1815: l_backflushTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR;
1816: l_issueTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE;
1817: l_push NUMBER := wip_constants.push;
1818: l_carton_grouping_id NUMBER;
1819: TYPE carton_tbl_t IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 1816: l_issueTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE;

1812: l_repetitive NUMBER := wip_constants.repetitive;
1813: l_msgCount NUMBER;
1814: l_revControlCode VARCHAR2(3);
1815: l_backflushTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR;
1816: l_issueTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE;
1817: l_push NUMBER := wip_constants.push;
1818: l_carton_grouping_id NUMBER;
1819: TYPE carton_tbl_t IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1820: carton_tbl carton_tbl_t;

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

2075: l_pickSetId := l_pickSetId + 1; --increment regardless
2076: end loop;
2077:
2078: if(l_lineCount > 0) then
2079: l_hdrRec.move_order_type := INV_Globals.G_MOVE_ORDER_MFG_PICK;
2080: inv_wip_picking_pvt.release_pick_batch(p_mo_header_rec => l_hdrRec,
2081: p_mo_line_rec_tbl => l_linesTable,
2082: p_auto_detail_flag => nvl(p_auto_detail_flag,'T'),
2083: p_print_pick_slip => nvl(p_print_pick_slip,'F'),