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.GMI_RESERVATION_PVT dependencies on IC_ITEM_MST

Line 153: l_ic_item_mst_rec GMI_Reservation_Util.ic_item_mst_rec;

149: l_converted_quantity NUMBER;
150: l_OPM_order_um VARCHAR2(4);
151: l_Apps_order_um VARCHAR2(3);
152: l_Apps_primary_um VARCHAR2(3);
153: l_ic_item_mst_rec GMI_Reservation_Util.ic_item_mst_rec;
154:
155: -- OPM 2115306
156: l_epsilon NUMBER;
157: n NUMBER;

Line 310: , x_ic_item_mst_rec => l_ic_item_mst_rec

306: GMI_Reservation_Util.Validation_for_Query
307: ( p_query_input => p_query_input
308: , x_opm_um => l_OPM_order_um
309: , x_apps_um => l_Apps_order_um
310: , x_ic_item_mst_rec => l_ic_item_mst_rec
311: , x_return_status => x_return_status
312: , x_msg_count => x_msg_count
313: , x_msg_data => x_msg_data
314: , x_error_code => x_error_code); /* Bug 2168710 - Added parameter */

Line 331: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT q OPM_order_um='||l_OPM_order_um||', item_um='||l_ic_item_mst_rec.item_um||'.');

327:
328: /* ============================================================================================= */
329: /* Convert reserved quantity (in ic_tran_pnd, so OPM) into the reservation_UOM of the SO. */
330: /* =============================================================================================*/
331: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT q OPM_order_um='||l_OPM_order_um||', item_um='||l_ic_item_mst_rec.item_um||'.');
332: IF (l_OPM_order_um <> l_ic_item_mst_rec.item_um)
333: THEN
334: GMICUOM.icuomcv(pitem_id => l_ic_item_mst_rec.item_id
335: , plot_id => 0

Line 332: IF (l_OPM_order_um <> l_ic_item_mst_rec.item_um)

328: /* ============================================================================================= */
329: /* Convert reserved quantity (in ic_tran_pnd, so OPM) into the reservation_UOM of the SO. */
330: /* =============================================================================================*/
331: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT q OPM_order_um='||l_OPM_order_um||', item_um='||l_ic_item_mst_rec.item_um||'.');
332: IF (l_OPM_order_um <> l_ic_item_mst_rec.item_um)
333: THEN
334: GMICUOM.icuomcv(pitem_id => l_ic_item_mst_rec.item_id
335: , plot_id => 0
336: , pcur_qty => l_quantity_to_convert

Line 334: GMICUOM.icuomcv(pitem_id => l_ic_item_mst_rec.item_id

330: /* =============================================================================================*/
331: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT q OPM_order_um='||l_OPM_order_um||', item_um='||l_ic_item_mst_rec.item_um||'.');
332: IF (l_OPM_order_um <> l_ic_item_mst_rec.item_um)
333: THEN
334: GMICUOM.icuomcv(pitem_id => l_ic_item_mst_rec.item_id
335: , plot_id => 0
336: , pcur_qty => l_quantity_to_convert
337: , pcur_uom => l_ic_item_mst_rec.item_um
338: , pnew_uom => l_OPM_order_um

Line 337: , pcur_uom => l_ic_item_mst_rec.item_um

333: THEN
334: GMICUOM.icuomcv(pitem_id => l_ic_item_mst_rec.item_id
335: , plot_id => 0
336: , pcur_qty => l_quantity_to_convert
337: , pcur_uom => l_ic_item_mst_rec.item_um
338: , pnew_uom => l_OPM_order_um
339: , onew_qty => l_converted_quantity);
340:
341: --

Line 364: GMI_Reservation_Util.ic_tran_rec_tbl(rec_index).non_inv := l_ic_item_mst_rec.noninv_ind;

360: /* Populate the mtl_reservation rec type */
361: /* and the ic_tran_rec table */
362: /* ============================================================================================= */
363: GMI_Reservation_Util.ic_tran_rec_tbl(rec_index).user_id := FND_GLOBAL.USER_ID;
364: GMI_Reservation_Util.ic_tran_rec_tbl(rec_index).non_inv := l_ic_item_mst_rec.noninv_ind;
365:
366: x_mtl_reservation_tbl(rec_index).reservation_id := GMI_Reservation_Util.ic_tran_rec_tbl(rec_index).trans_id;
367: x_mtl_reservation_tbl(rec_index).organization_id := p_query_input.organization_id;
368: x_mtl_reservation_tbl(rec_index).inventory_item_id := l_ic_item_mst_rec.inventory_item_id;

Line 368: x_mtl_reservation_tbl(rec_index).inventory_item_id := l_ic_item_mst_rec.inventory_item_id;

364: GMI_Reservation_Util.ic_tran_rec_tbl(rec_index).non_inv := l_ic_item_mst_rec.noninv_ind;
365:
366: x_mtl_reservation_tbl(rec_index).reservation_id := GMI_Reservation_Util.ic_tran_rec_tbl(rec_index).trans_id;
367: x_mtl_reservation_tbl(rec_index).organization_id := p_query_input.organization_id;
368: x_mtl_reservation_tbl(rec_index).inventory_item_id := l_ic_item_mst_rec.inventory_item_id;
369: x_mtl_reservation_tbl(rec_index).demand_source_header_id := GMI_Reservation_Util.ic_tran_rec_tbl(rec_index).doc_id;
370: x_mtl_reservation_tbl(rec_index).demand_source_line_id := GMI_Reservation_Util.ic_tran_rec_tbl(rec_index).line_id;
371: /* hwahdani 1388867 */
372: x_mtl_reservation_tbl(rec_index).demand_source_type_id := INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE;

Line 492: l_ic_item_mst_rec GMI_Reservation_Util.ic_item_mst_rec;

488: l_mtl_rsv_tbl_count NUMBER;
489: x_error_code NUMBER;
490: l_lock_status BOOLEAN;
491: l_allocation_rec GMI_AUTO_ALLOCATE_PUB.gmi_allocation_rec;
492: l_ic_item_mst_rec GMI_Reservation_Util.ic_item_mst_rec;
493: l_cust_no op_cust_mst.cust_no%TYPE;
494: l_orgn_code sy_orgn_mst.orgn_code%TYPE;
495: l_trans_id NUMBER;
496: X_ALLOCATED_QTY1 NUMBER;

Line 612: , x_ic_item_mst_rec => l_ic_item_mst_rec

608: /* =============================================================================================*/
609: GMI_Reservation_Util.Validation_before_Allocate(
610: p_mtl_rsv_rec => p_rsv_rec
611: , x_allocation_rec => l_allocation_rec
612: , x_ic_item_mst_rec => l_ic_item_mst_rec
613: , x_orgn_code => l_orgn_code
614: , x_return_status => x_return_status
615: , x_msg_count => x_msg_count
616: , x_msg_data => x_msg_data);

Line 632: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT c : alloc_class='||l_ic_item_mst_rec.alloc_class||'.');

628:
629:
630: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT c : default_loct='||GMI_Reservation_Util.G_DEFAULT_LOCT||'.');
631: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT c : default_lot_index='||l_default_lot_index||'.');
632: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT c : alloc_class='||l_ic_item_mst_rec.alloc_class||'.');
633:
634: /* =============================================================================================*/
635: /* No allocation exist and rules are AUTO_ALLOC. Then call OPM_auto_allocation and the transaction engine.*/
636: /* =============================================================================================*/

Line 705: i_item_id => l_ic_item_mst_rec.item_id

701: /* Lock rows in ic_loct_inv.*/
702: /* =============================================================================================*/
703: /* Bug 2521215 Do not Lock Inventory when Allocating
704: GMI_Locks.Lock_Inventory(
705: i_item_id => l_ic_item_mst_rec.item_id
706: , i_whse_code => l_allocation_rec.whse_code
707: , o_lock_status => l_lock_status
708: );
709:

Line 733: , p_ic_item_mst_rec => l_ic_item_mst_rec

729: /* bug 1687531, moved here from out side of if */
730: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT c before Create_Default_Lot orgn_code='||l_orgn_code||', trans_id(if not null then UPDATE default_lot)='||l_trans_id);
731: GMI_Reservation_Util.Create_Default_Lot(
732: p_allocation_rec => l_allocation_rec
733: , p_ic_item_mst_rec => l_ic_item_mst_rec
734: , p_orgn_code => l_orgn_code
735: , p_trans_id => l_trans_id
736: , x_return_status => x_return_status
737: , x_msg_count => x_msg_count

Line 761: GMI_reservation_Util.PrintLn('(opm_dbg) l_ic_item_mst_rec.item_id='||l_ic_item_mst_rec.item_id);

757:
758:
759: GMI_reservation_Util.PrintLn('(opm_dbg) p_rsv_rec.inventory_item_id='||p_rsv_rec.inventory_item_id);
760: GMI_reservation_Util.PrintLn('(opm_dbg) opm_item_id='||l_default_tran_rec.item_id);
761: GMI_reservation_Util.PrintLn('(opm_dbg) l_ic_item_mst_rec.item_id='||l_ic_item_mst_rec.item_id);
762:
763: /* Start bug 2711467 */
764: IF (l_default_tran_rec.item_id <> l_ic_item_mst_rec.item_id) THEN
765: l_default_tran_rec.item_id := l_ic_item_mst_rec.item_id;

Line 764: IF (l_default_tran_rec.item_id <> l_ic_item_mst_rec.item_id) THEN

760: GMI_reservation_Util.PrintLn('(opm_dbg) opm_item_id='||l_default_tran_rec.item_id);
761: GMI_reservation_Util.PrintLn('(opm_dbg) l_ic_item_mst_rec.item_id='||l_ic_item_mst_rec.item_id);
762:
763: /* Start bug 2711467 */
764: IF (l_default_tran_rec.item_id <> l_ic_item_mst_rec.item_id) THEN
765: l_default_tran_rec.item_id := l_ic_item_mst_rec.item_id;
766: l_default_tran_rec.trans_um := l_ic_item_mst_rec.item_um;
767: l_default_tran_rec.trans_um2 := l_ic_item_mst_rec.item_um2;
768: END IF;

Line 765: l_default_tran_rec.item_id := l_ic_item_mst_rec.item_id;

761: GMI_reservation_Util.PrintLn('(opm_dbg) l_ic_item_mst_rec.item_id='||l_ic_item_mst_rec.item_id);
762:
763: /* Start bug 2711467 */
764: IF (l_default_tran_rec.item_id <> l_ic_item_mst_rec.item_id) THEN
765: l_default_tran_rec.item_id := l_ic_item_mst_rec.item_id;
766: l_default_tran_rec.trans_um := l_ic_item_mst_rec.item_um;
767: l_default_tran_rec.trans_um2 := l_ic_item_mst_rec.item_um2;
768: END IF;
769:

Line 766: l_default_tran_rec.trans_um := l_ic_item_mst_rec.item_um;

762:
763: /* Start bug 2711467 */
764: IF (l_default_tran_rec.item_id <> l_ic_item_mst_rec.item_id) THEN
765: l_default_tran_rec.item_id := l_ic_item_mst_rec.item_id;
766: l_default_tran_rec.trans_um := l_ic_item_mst_rec.item_um;
767: l_default_tran_rec.trans_um2 := l_ic_item_mst_rec.item_um2;
768: END IF;
769:
770: /* End bug 2711467*/

Line 767: l_default_tran_rec.trans_um2 := l_ic_item_mst_rec.item_um2;

763: /* Start bug 2711467 */
764: IF (l_default_tran_rec.item_id <> l_ic_item_mst_rec.item_id) THEN
765: l_default_tran_rec.item_id := l_ic_item_mst_rec.item_id;
766: l_default_tran_rec.trans_um := l_ic_item_mst_rec.item_um;
767: l_default_tran_rec.trans_um2 := l_ic_item_mst_rec.item_um2;
768: END IF;
769:
770: /* End bug 2711467*/
771:

Line 806: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT c : alloc_class='||l_ic_item_mst_rec.alloc_class||', lot_ctl='||l_ic_item_mst_rec.lot_ctl||', loct_ctl='||l_ic_item_mst_rec.loct_ctl);

802: FETCH get_whse_ctl INTO l_whse_ctl;
803: CLOSE get_whse_ctl;
804: -- B1766055 END
805: GMI_reservation_Util.PrintLn('OPM Whse LOCATION CTL is : ' || l_whse_ctl);
806: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT c : alloc_class='||l_ic_item_mst_rec.alloc_class||', lot_ctl='||l_ic_item_mst_rec.lot_ctl||', loct_ctl='||l_ic_item_mst_rec.loct_ctl);
807: -- added by fabdi 10/01/2001
808: -- fix for bug # 1574957
809: IF (l_ic_item_mst_rec.lot_ctl > 0) OR
810: (l_ic_item_mst_rec.loct_ctl > 0 AND l_whse_ctl > 0)

Line 809: IF (l_ic_item_mst_rec.lot_ctl > 0) OR

805: GMI_reservation_Util.PrintLn('OPM Whse LOCATION CTL is : ' || l_whse_ctl);
806: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT c : alloc_class='||l_ic_item_mst_rec.alloc_class||', lot_ctl='||l_ic_item_mst_rec.lot_ctl||', loct_ctl='||l_ic_item_mst_rec.loct_ctl);
807: -- added by fabdi 10/01/2001
808: -- fix for bug # 1574957
809: IF (l_ic_item_mst_rec.lot_ctl > 0) OR
810: (l_ic_item_mst_rec.loct_ctl > 0 AND l_whse_ctl > 0)
811: -- end fabdi
812: THEN
813: IF ( (l_ic_item_mst_rec.alloc_class <> FND_API.G_MISS_CHAR

Line 810: (l_ic_item_mst_rec.loct_ctl > 0 AND l_whse_ctl > 0)

806: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT c : alloc_class='||l_ic_item_mst_rec.alloc_class||', lot_ctl='||l_ic_item_mst_rec.lot_ctl||', loct_ctl='||l_ic_item_mst_rec.loct_ctl);
807: -- added by fabdi 10/01/2001
808: -- fix for bug # 1574957
809: IF (l_ic_item_mst_rec.lot_ctl > 0) OR
810: (l_ic_item_mst_rec.loct_ctl > 0 AND l_whse_ctl > 0)
811: -- end fabdi
812: THEN
813: IF ( (l_ic_item_mst_rec.alloc_class <> FND_API.G_MISS_CHAR
814: AND l_ic_item_mst_rec.alloc_class IS NOT NULL )

Line 813: IF ( (l_ic_item_mst_rec.alloc_class <> FND_API.G_MISS_CHAR

809: IF (l_ic_item_mst_rec.lot_ctl > 0) OR
810: (l_ic_item_mst_rec.loct_ctl > 0 AND l_whse_ctl > 0)
811: -- end fabdi
812: THEN
813: IF ( (l_ic_item_mst_rec.alloc_class <> FND_API.G_MISS_CHAR
814: AND l_ic_item_mst_rec.alloc_class IS NOT NULL )
815: AND p_force_reservation_flag = FND_API.G_TRUE)
816: THEN
817: /* 7-Nov-2000 odaboval : Bug 1479751 : Added the test and a message.*/

Line 814: AND l_ic_item_mst_rec.alloc_class IS NOT NULL )

810: (l_ic_item_mst_rec.loct_ctl > 0 AND l_whse_ctl > 0)
811: -- end fabdi
812: THEN
813: IF ( (l_ic_item_mst_rec.alloc_class <> FND_API.G_MISS_CHAR
814: AND l_ic_item_mst_rec.alloc_class IS NOT NULL )
815: AND p_force_reservation_flag = FND_API.G_TRUE)
816: THEN
817: /* 7-Nov-2000 odaboval : Bug 1479751 : Added the test and a message.*/
818: /* comment this out, no need after bug 2245351*/

Line 840: i_item_id => l_ic_item_mst_rec.item_id

836: /* Lock rows in ic_loct_inv.*/
837: /* =============================================================================================*/
838: /* Bug 2521215 Do not Lock Inventory when Allocating
839: GMI_Locks.Lock_Inventory(
840: i_item_id => l_ic_item_mst_rec.item_id
841: , i_whse_code => l_allocation_rec.whse_code
842: , o_lock_status => l_lock_status
843: );
844:

Line 1947: FROM ic_item_mst

1943:
1944: -- Get item ctl
1945: CURSOR get_item_ctl IS
1946: SELECT loct_ctl,lot_ctl,noninv_ind
1947: FROM ic_item_mst
1948: WHERE item_id=p_item_id;
1949:
1950: -- Get the inventory_item_id for the org
1951: Cursor get_inventory_item_id IS

Line 1954: , ic_item_mst ic

1950: -- Get the inventory_item_id for the org
1951: Cursor get_inventory_item_id IS
1952: Select inventory_item_id
1953: From mtl_system_items_b mtl
1954: , ic_item_mst ic
1955: Where ic.item_id = p_item_id
1956: and mtl.organization_id = p_organization_id
1957: and ic.item_no = mtl.segment1;
1958:

Line 2494: from ic_item_mst

2490:
2491: -- get grade_ctl
2492: Cursor get_grade_ctl IS
2493: Select grade_ctl
2494: from ic_item_mst
2495: where item_id=p_item_id;
2496:
2497: -- Get qty reserved for this order line for a grade
2498: CURSOR reserved_quantity_for_grd(l_whse_code VARCHAR2,

Line 2740: FROM ic_item_mst

2736:
2737: -- Get item ctl
2738: CURSOR get_item_ctl IS
2739: SELECT loct_ctl,lot_ctl,noninv_ind
2740: FROM ic_item_mst
2741: WHERE item_id=p_item_id;
2742:
2743: BEGIN
2744:

Line 2981: FROM ic_item_mst

2977: itm_group_rec shipset_item_group%ROWTYPE;
2978:
2979: CURSOR opm_itm(l_apps_itm_id NUMBER) IS
2980: SELECT item_id
2981: FROM ic_item_mst
2982: WHERE delete_mark = 0
2983: AND item_no in (SELECT segment1
2984: FROM mtl_system_items
2985: WHERE organization_id = p_organization_id

Line 2990: FROM ic_item_mst

2986: AND inventory_item_id = l_apps_itm_id);
2987:
2988: CURSOR get_item_ctl(l_opm_itm_id NUMBER) IS
2989: SELECT loct_ctl,lot_ctl,noninv_ind
2990: FROM ic_item_mst
2991: WHERE item_id=l_opm_itm_id;
2992:
2993: CURSOR reserved_quantity_nonctl(l_apps_itm_id NUMBER ) is
2994: Select sum(nvl(requested_quantity,0)), sum(nvl(requested_quantity2,0))