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.GMD_SAMPLES_GRP dependencies on MTL_LOT_NUMBERS

Line 1998: FROM MTL_LOT_NUMBERS

1994: FROM DUAL;
1995:
1996: CURSOR Cur_get_lot IS
1997: SELECT lot_number
1998: FROM MTL_LOT_NUMBERS
1999: WHERE inventory_item_id = p_update_change_disp_rec.inventory_item_id
2000: AND organization_id = p_update_change_disp_rec.organization_id
2001: AND parent_lot_number = p_update_change_disp_rec.parent_lot_number ;
2002:

Line 2218: l_parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE;

2214: -- l_trans_rec_lot_status GMIGAPI.qty_rec_typ; --bug 4165704
2215: -- l_tempb BOOLEAN;
2216:
2217: l_data VARCHAR2(2000);
2218: l_parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE;
2219: l_lot_number MTL_LOT_NUMBERS.lot_number%TYPE;
2220: l_inventory_item_number VARCHAR2(2000);
2221: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
2222: l_organization_id NUMBER;

Line 2219: l_lot_number MTL_LOT_NUMBERS.lot_number%TYPE;

2215: -- l_tempb BOOLEAN;
2216:
2217: l_data VARCHAR2(2000);
2218: l_parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE;
2219: l_lot_number MTL_LOT_NUMBERS.lot_number%TYPE;
2220: l_inventory_item_number VARCHAR2(2000);
2221: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
2222: l_organization_id NUMBER;
2223: l_batch_id NUMBER(15);

Line 2266: CURSOR c_mtl_lot_numbers(p_parent_lot_number IN VARCHAR2,

2262: get_curr_lot_status_rec GET_CURR_LOT_STATUS_REC_TYP ;
2263:
2264: -- Manish Gupta B3143795, Update hold date
2265: -- Bug 4165704: changed so that cursor is going against correct table
2266: CURSOR c_mtl_lot_numbers(p_parent_lot_number IN VARCHAR2,
2267: p_organization_id IN NUMBER,
2268: p_inventory_item_id IN NUMBER) IS
2269: SELECT hold_date
2270: FROM mtl_lot_numbers

Line 2270: FROM mtl_lot_numbers

2266: CURSOR c_mtl_lot_numbers(p_parent_lot_number IN VARCHAR2,
2267: p_organization_id IN NUMBER,
2268: p_inventory_item_id IN NUMBER) IS
2269: SELECT hold_date
2270: FROM mtl_lot_numbers
2271: WHERE parent_lot_number = p_parent_lot_number
2272: AND inventory_item_id = p_inventory_item_id
2273: AND organization_id = p_organization_id;
2274:

Line 2280: FROM mtl_lot_numbers

2276: CURSOR c_lots (p_parent_lot_number IN VARCHAR2,
2277: p_organization_id IN NUMBER,
2278: p_inventory_item_id IN NUMBER) IS
2279: SELECT 1
2280: FROM mtl_lot_numbers
2281: WHERE parent_lot_number = p_parent_lot_number
2282: AND organization_id = p_organization_id
2283: AND inventory_item_id = p_inventory_item_id;
2284:

Line 2291: FROM MTL_LOT_NUMBERS

2287: p_organization_id IN NUMBER,
2288: p_inventory_item_id IN NUMBER) IS
2289: SELECT lot_number,
2290: status_id
2291: FROM MTL_LOT_NUMBERS
2292: WHERE inventory_item_id = l_inventory_item_id
2293: AND organization_id = l_organization_id
2294: AND lot_number = l_lot_number ;
2295:

Line 2414: -- Bug 4165704: changed cursor to use lot_number, parent_lot_number and mtl_lot_numbers table

2410:
2411: END IF;
2412:
2413: -- Manish Gupta B3143795, Update hold date
2414: -- Bug 4165704: changed cursor to use lot_number, parent_lot_number and mtl_lot_numbers table
2415: IF l_parent_lot_number IS NOT NULL
2416: AND l_lot_number IS NULL THEN
2417: FOR l_lots in c_lots(
2418: l_parent_lot_number,

Line 2423: --Lock the mtl_lot_numbers before updating.

2419: l_organization_id ,
2420: l_inventory_item_id)
2421: LOOP
2422:
2423: --Lock the mtl_lot_numbers before updating.
2424: OPEN c_mtl_lot_numbers(l_parent_lot_number,
2425: l_inventory_item_id,
2426: l_organization_id);
2427: CLOSE c_mtl_lot_numbers;

Line 2424: OPEN c_mtl_lot_numbers(l_parent_lot_number,

2420: l_inventory_item_id)
2421: LOOP
2422:
2423: --Lock the mtl_lot_numbers before updating.
2424: OPEN c_mtl_lot_numbers(l_parent_lot_number,
2425: l_inventory_item_id,
2426: l_organization_id);
2427: CLOSE c_mtl_lot_numbers;
2428:

Line 2427: CLOSE c_mtl_lot_numbers;

2423: --Lock the mtl_lot_numbers before updating.
2424: OPEN c_mtl_lot_numbers(l_parent_lot_number,
2425: l_inventory_item_id,
2426: l_organization_id);
2427: CLOSE c_mtl_lot_numbers;
2428:
2429: -- Bug 4165704: hold date is now updated on mtl_lot_numbers
2430: --UPDATE ic_lots_cpg
2431: --SET ic_hold_date = p_hold_date

Line 2429: -- Bug 4165704: hold date is now updated on mtl_lot_numbers

2425: l_inventory_item_id,
2426: l_organization_id);
2427: CLOSE c_mtl_lot_numbers;
2428:
2429: -- Bug 4165704: hold date is now updated on mtl_lot_numbers
2430: --UPDATE ic_lots_cpg
2431: --SET ic_hold_date = p_hold_date
2432: --WHERE item_id =l_lot_number.item_id
2433: --AND lot_id = l_lot_number.lot_id;

Line 2434: UPDATE mtl_lot_numbers

2430: --UPDATE ic_lots_cpg
2431: --SET ic_hold_date = p_hold_date
2432: --WHERE item_id =l_lot_number.item_id
2433: --AND lot_id = l_lot_number.lot_id;
2434: UPDATE mtl_lot_numbers
2435: SET hold_date = p_hold_date
2436: WHERE inventory_item_id = l_inventory_item_id
2437: AND organization_id = l_organization_id
2438: AND ((parent_lot_number = l_parent_lot_number )

Line 2444: UPDATE mtl_lot_numbers

2440: AND parent_lot_number IS NULL) );
2441: END LOOP;
2442:
2443: ELSIF l_lot_number IS NOT NULL THEN
2444: UPDATE mtl_lot_numbers
2445: SET hold_date = p_hold_date
2446: WHERE inventory_item_id = l_inventory_item_id
2447: AND organization_id = l_organization_id
2448: AND lot_number = l_lot_number;

Line 2483: FROM mtl_lot_numbers

2479: --ELSE
2480: OPEN get_curr_grade_cv FOR
2481: SELECT lot_number,
2482: grade_code
2483: FROM mtl_lot_numbers
2484: WHERE inventory_item_id = l_inventory_item_id
2485: AND organization_id = l_organization_id
2486: AND ((parent_lot_number = l_parent_lot_number )
2487: OR ( lot_number = l_parent_lot_number

Line 2561: FROM mtl_lot_numbers

2557: -- only update the one lot specified
2558: OPEN get_curr_grade_cv FOR
2559: SELECT lot_number,
2560: grade_code
2561: FROM mtl_lot_numbers
2562: WHERE inventory_item_id = l_inventory_item_id
2563: AND organization_id = l_organization_id
2564: AND lot_number = l_lot_number
2565: AND grade_code <> p_to_grade_code;

Line 2612: -- 3. use mtl_lot_numbers instead of ic_lots_mst

2608: IF p_to_lot_status_id IS NOT NULL THEN
2609: -- Bug 4165704: For inventory convergence:
2610: -- 1. removed sublot, lot_id
2611: -- 2. changed lot_no to lot_number
2612: -- 3. use mtl_lot_numbers instead of ic_lots_mst
2613: -- 4. use parent_lot_number and changed logic so that if parent lot specified
2614: -- but lot number is not specified, all lots for that parent are updated
2615:
2616: -- IF l_sublot_no IS NOT NULL THEN

Line 2633: FROM MTL_LOT_NUMBERS

2629: -- update all lots for the parent lot specified
2630: /* OPEN get_curr_lot_status_cv FOR
2631: SELECT lot_number,
2632: status_id
2633: FROM MTL_LOT_NUMBERS
2634: WHERE inventory_item_id = l_inventory_item_id
2635: AND organization_id = l_organization_id
2636: AND ((parent_lot_number = l_parent_lot_number )
2637: OR ( lot_number = l_parent_lot_number

Line 2648: FROM MTL_LOT_NUMBERS a, mtl_item_locations_kfv b -- 50061731

2644:
2645: OPEN get_curr_lot_status_cv FOR
2646: SELECT lot_number,
2647: a.status_id
2648: FROM MTL_LOT_NUMBERS a, mtl_item_locations_kfv b -- 50061731
2649: WHERE a.inventory_item_id = l_inventory_item_id
2650: AND a.organization_id = l_organization_id
2651: AND ((a.parent_lot_number = l_parent_lot_number )
2652: OR ( a.lot_number = l_parent_lot_number

Line 2663: FROM MTL_LOT_NUMBERS a

2659: */
2660: OPEN get_curr_lot_status_cv FOR
2661: SELECT lot_number,
2662: a.status_id
2663: FROM MTL_LOT_NUMBERS a
2664: WHERE a.inventory_item_id = l_inventory_item_id
2665: AND a.organization_id = l_organization_id
2666: AND ((a.parent_lot_number = l_parent_lot_number )
2667: OR ( a.lot_number = l_parent_lot_number

Line 3036: FROM mtl_lot_numbers

3032:
3033: -- Bug 4165704: changed for inventory convergence
3034: CURSOR c_item_lot IS
3035: SELECT 1
3036: FROM mtl_lot_numbers
3037: WHERE organization_id = p_sample.organization_id
3038: AND inventory_item_id = p_sample.inventory_item_id
3039: AND lot_number = p_sample.lot_number;
3040:

Line 4692: FROM mtl_lot_numbers

4688: Added for BUG#4695552.
4689: =================================*/
4690: CURSOR get_grade(v_organization NUMBER, v_lot_number VARCHAR2) IS
4691: SELECT grade_code
4692: FROM mtl_lot_numbers
4693: WHERE organization_id = v_organization
4694: AND lot_number = v_lot_number;
4695:
4696: -- Exceptions