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 2180: FROM MTL_LOT_NUMBERS

2176: FROM DUAL;
2177:
2178: CURSOR Cur_get_lot IS
2179: SELECT lot_number
2180: FROM MTL_LOT_NUMBERS
2181: WHERE inventory_item_id = p_update_change_disp_rec.inventory_item_id
2182: AND organization_id = p_update_change_disp_rec.organization_id
2183: AND parent_lot_number = p_update_change_disp_rec.parent_lot_number ;
2184:

Line 2416: l_parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE;

2412: -- l_trans_rec_lot_status GMIGAPI.qty_rec_typ; --bug 4165704
2413: -- l_tempb BOOLEAN;
2414:
2415: l_data VARCHAR2(2000);
2416: l_parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE;
2417: l_lot_number MTL_LOT_NUMBERS.lot_number%TYPE;
2418: L_Inventory_item_number VARCHAR2(2000);
2419: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
2420: l_organization_id NUMBER;

Line 2417: l_lot_number MTL_LOT_NUMBERS.lot_number%TYPE;

2413: -- l_tempb BOOLEAN;
2414:
2415: l_data VARCHAR2(2000);
2416: l_parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE;
2417: l_lot_number MTL_LOT_NUMBERS.lot_number%TYPE;
2418: L_Inventory_item_number VARCHAR2(2000);
2419: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
2420: l_organization_id NUMBER;
2421: l_batch_id NUMBER(15);

Line 2473: CURSOR c_mtl_lot_numbers(p_parent_lot_number IN VARCHAR2,

2469: get_curr_lot_status_rec GET_CURR_LOT_STATUS_REC_TYP ;
2470:
2471: -- Manish Gupta B3143795, Update hold date
2472: -- Bug 4165704: changed so that cursor is going against correct table
2473: CURSOR c_mtl_lot_numbers(p_parent_lot_number IN VARCHAR2,
2474: p_organization_id IN NUMBER,
2475: p_inventory_item_id IN NUMBER) IS
2476: SELECT hold_date
2477: FROM mtl_lot_numbers

Line 2477: FROM mtl_lot_numbers

2473: CURSOR c_mtl_lot_numbers(p_parent_lot_number IN VARCHAR2,
2474: p_organization_id IN NUMBER,
2475: p_inventory_item_id IN NUMBER) IS
2476: SELECT hold_date
2477: FROM mtl_lot_numbers
2478: WHERE parent_lot_number = p_parent_lot_number
2479: AND inventory_item_id = p_inventory_item_id
2480: AND organization_id = p_organization_id;
2481:

Line 2487: FROM mtl_lot_numbers

2483: CURSOR c_lots (p_parent_lot_number IN VARCHAR2,
2484: p_organization_id IN NUMBER,
2485: p_inventory_item_id IN NUMBER) IS
2486: SELECT 1
2487: FROM mtl_lot_numbers
2488: WHERE parent_lot_number = p_parent_lot_number
2489: AND organization_id = p_organization_id
2490: AND inventory_item_id = p_inventory_item_id;
2491:

Line 2498: FROM MTL_LOT_NUMBERS

2494: p_organization_id IN NUMBER,
2495: p_inventory_item_id IN NUMBER) IS
2496: SELECT lot_number,
2497: status_id
2498: FROM MTL_LOT_NUMBERS
2499: WHERE inventory_item_id = l_inventory_item_id
2500: AND organization_id = l_organization_id
2501: AND lot_number = l_lot_number ;
2502:

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

2668:
2669: END IF;
2670:
2671: -- Manish Gupta B3143795, Update hold date
2672: -- Bug 4165704: changed cursor to use lot_number, parent_lot_number and mtl_lot_numbers table
2673: IF l_parent_lot_number IS NOT NULL
2674: AND l_lot_number IS NULL THEN
2675: FOR l_lots in c_lots(
2676: l_parent_lot_number,

Line 2681: --Lock the mtl_lot_numbers before updating.

2677: l_organization_id ,
2678: l_inventory_item_id)
2679: LOOP
2680:
2681: --Lock the mtl_lot_numbers before updating.
2682: OPEN c_mtl_lot_numbers(l_parent_lot_number,
2683: l_inventory_item_id,
2684: l_organization_id);
2685: CLOSE c_mtl_lot_numbers;

Line 2682: OPEN c_mtl_lot_numbers(l_parent_lot_number,

2678: l_inventory_item_id)
2679: LOOP
2680:
2681: --Lock the mtl_lot_numbers before updating.
2682: OPEN c_mtl_lot_numbers(l_parent_lot_number,
2683: l_inventory_item_id,
2684: l_organization_id);
2685: CLOSE c_mtl_lot_numbers;
2686:

Line 2685: CLOSE c_mtl_lot_numbers;

2681: --Lock the mtl_lot_numbers before updating.
2682: OPEN c_mtl_lot_numbers(l_parent_lot_number,
2683: l_inventory_item_id,
2684: l_organization_id);
2685: CLOSE c_mtl_lot_numbers;
2686:
2687: -- Bug 4165704: hold date is now updated on mtl_lot_numbers
2688: --UPDATE ic_lots_cpg
2689: --SET ic_hold_date = p_hold_date

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

2683: l_inventory_item_id,
2684: l_organization_id);
2685: CLOSE c_mtl_lot_numbers;
2686:
2687: -- Bug 4165704: hold date is now updated on mtl_lot_numbers
2688: --UPDATE ic_lots_cpg
2689: --SET ic_hold_date = p_hold_date
2690: --WHERE item_id =l_lot_number.item_id
2691: --AND lot_id = l_lot_number.lot_id;

Line 2692: UPDATE mtl_lot_numbers

2688: --UPDATE ic_lots_cpg
2689: --SET ic_hold_date = p_hold_date
2690: --WHERE item_id =l_lot_number.item_id
2691: --AND lot_id = l_lot_number.lot_id;
2692: UPDATE mtl_lot_numbers
2693: SET hold_date = p_hold_date
2694: WHERE inventory_item_id = l_inventory_item_id
2695: AND organization_id = l_organization_id
2696: AND ((parent_lot_number = l_parent_lot_number )

Line 2702: UPDATE mtl_lot_numbers

2698: AND parent_lot_number IS NULL) );
2699: END LOOP;
2700:
2701: ELSIF l_lot_number IS NOT NULL THEN
2702: UPDATE mtl_lot_numbers
2703: SET hold_date = p_hold_date
2704: WHERE inventory_item_id = l_inventory_item_id
2705: AND organization_id = l_organization_id
2706: AND lot_number = l_lot_number;

Line 2741: FROM mtl_lot_numbers

2737: --ELSE
2738: OPEN get_curr_grade_cv FOR
2739: SELECT lot_number,
2740: grade_code
2741: FROM mtl_lot_numbers
2742: WHERE inventory_item_id = l_inventory_item_id
2743: AND organization_id = l_organization_id
2744: AND ((parent_lot_number = l_parent_lot_number )
2745: OR ( lot_number = l_parent_lot_number

Line 2819: FROM mtl_lot_numbers

2815: -- only update the one lot specified
2816: OPEN get_curr_grade_cv FOR
2817: SELECT lot_number,
2818: grade_code
2819: FROM mtl_lot_numbers
2820: WHERE inventory_item_id = l_inventory_item_id
2821: AND organization_id = l_organization_id
2822: AND lot_number = l_lot_number
2823: AND grade_code <> p_to_grade_code;

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

2866: IF p_to_lot_status_id IS NOT NULL THEN
2867: -- Bug 4165704: For inventory convergence:
2868: -- 1. removed sublot, lot_id
2869: -- 2. changed lot_no to lot_number
2870: -- 3. use mtl_lot_numbers instead of ic_lots_mst
2871: -- 4. use parent_lot_number and changed logic so that if parent lot specified
2872: -- but lot number is not specified, all lots for that parent are updated
2873:
2874: -- IF l_sublot_no IS NOT NULL THEN

Line 2915: FROM MTL_LOT_NUMBERS

2911: -- update all lots for the parent lot specified
2912: /* OPEN get_curr_lot_status_cv FOR
2913: SELECT lot_number,
2914: status_id
2915: FROM MTL_LOT_NUMBERS
2916: WHERE inventory_item_id = l_inventory_item_id
2917: AND organization_id = l_organization_id
2918: AND ((parent_lot_number = l_parent_lot_number )
2919: OR ( lot_number = l_parent_lot_number

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

2926:
2927: OPEN get_curr_lot_status_cv FOR
2928: SELECT lot_number,
2929: a.status_id
2930: FROM MTL_LOT_NUMBERS a, mtl_item_locations_kfv b -- 50061731
2931: WHERE a.inventory_item_id = l_inventory_item_id
2932: AND a.organization_id = l_organization_id
2933: AND ((a.parent_lot_number = l_parent_lot_number )
2934: OR ( a.lot_number = l_parent_lot_number

Line 2945: FROM MTL_LOT_NUMBERS a

2941: */
2942: OPEN get_curr_lot_status_cv FOR
2943: SELECT lot_number,
2944: a.status_id
2945: FROM MTL_LOT_NUMBERS a
2946: WHERE a.inventory_item_id = l_inventory_item_id
2947: AND a.organization_id = l_organization_id
2948: AND ((a.parent_lot_number = l_parent_lot_number )
2949: OR ( a.lot_number = l_parent_lot_number

Line 3631: FROM mtl_lot_numbers

3627:
3628: -- Bug 4165704: changed for inventory convergence
3629: CURSOR c_item_lot IS
3630: SELECT 1
3631: FROM mtl_lot_numbers
3632: WHERE organization_id = p_sample.organization_id
3633: AND inventory_item_id = p_sample.inventory_item_id
3634: AND lot_number = p_sample.lot_number;
3635:

Line 5343: FROM mtl_lot_numbers

5339: Added for BUG#4695552.
5340: =================================*/
5341: CURSOR get_grade(v_organization NUMBER, v_lot_number VARCHAR2) IS
5342: SELECT grade_code
5343: FROM mtl_lot_numbers
5344: WHERE organization_id = v_organization
5345: AND lot_number = v_lot_number;
5346:
5347: -- Exceptions