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.INV_LOT_API_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 2442: UPDATE mtl_system_items_b

2438: print_debug('before updating msi '||p_lot_prefix,9);
2439: END IF;
2440:
2441: if( p_lot_generation = 2 AND p_lot_uniqueness = 1 ) THEN
2442: UPDATE mtl_system_items_b
2443: SET start_auto_lot_number = p_new_suffix
2444: -- Bug# 7298723
2445: -- WHERE organization_id = p_org_id
2446: WHERE auto_lot_alpha_prefix = p_lot_prefix

Line 2656: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly

2652: ======================================*/
2653: CURSOR get_item_data IS
2654: SELECT child_lot_flag, parent_child_generation_flag,
2655: child_lot_prefix, child_lot_starting_number
2656: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly
2657: WHERE organization_id = p_org_id
2658: AND inventory_item_id = p_inventory_item_id;
2659:
2660: x_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;

Line 4261: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;

4257: , p_supplier_lot_number IN VARCHAR2
4258: , p_vendor_name IN VARCHAR2
4259: ) IS
4260: /*Program variables declaration */
4261: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;
4262: l_chk_lot_uniqueness BOOLEAN;
4263: l_wms_installed VARCHAR2(5);
4264: l_lot_number_uniqueness NUMBER;
4265: l_return_status VARCHAR2(1);

Line 7861: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly

7857: CURSOR get_item_data IS
7858: SELECT child_lot_flag, parent_child_generation_flag,
7859: child_lot_prefix, child_lot_validation_flag,
7860: child_lot_starting_number
7861: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly
7862: WHERE organization_id = p_organization_id
7863: AND inventory_item_id = p_inventory_item_id;
7864:
7865: l_item_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;

Line 8337: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly

8333: CURSOR get_item_details( org_id IN NUMBER
8334: , item_id IN NUMBER) IS
8335: SELECT NVL( lot_divisible_flag, 'Y')
8336: ,lot_control_code
8337: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly
8338: WHERE organization_id = org_id
8339: AND inventory_item_id = item_id;
8340:
8341: /*====================================

Line 9186: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly

9182: child_lot_flag,
9183: copy_lot_attribute_flag,
9184: shelf_life_code,
9185: grade_control_flag
9186: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly
9187: WHERE inventory_item_id = cp_inventory_item_id
9188: AND organization_id = cp_organization_id;
9189:
9190: l_chk_msi_attr_rec c_chk_msi_attr%ROWTYPE;