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_STATUS_PKG dependencies on FND_GLOBAL

Line 383: , last_updated_by = FND_GLOBAL.USER_ID

379: END IF;
380: if p_sub_status_id >0 then
381: update mtl_secondary_inventories
382: set status_id = p_sub_status_id
383: , last_updated_by = FND_GLOBAL.USER_ID
384: , last_update_date = SYSDATE
385: , last_update_login = FND_GLOBAL.LOGIN_ID
386: where organization_id = p_organization_id
387: and secondary_inventory_name = p_sub_code;

Line 385: , last_update_login = FND_GLOBAL.LOGIN_ID

381: update mtl_secondary_inventories
382: set status_id = p_sub_status_id
383: , last_updated_by = FND_GLOBAL.USER_ID
384: , last_update_date = SYSDATE
385: , last_update_login = FND_GLOBAL.LOGIN_ID
386: where organization_id = p_organization_id
387: and secondary_inventory_name = p_sub_code;
388:
389: l_status_rec.zone_code := p_sub_code;

Line 404: , last_updated_by = FND_GLOBAL.USER_ID

400: END IF;
401: if p_loc_status_id >0 then
402: update mtl_item_locations
403: set status_id = p_loc_status_id
404: , last_updated_by = FND_GLOBAL.USER_ID
405: , last_update_date = SYSDATE
406: , last_update_login = FND_GLOBAL.LOGIN_ID
407: where organization_id = p_organization_id
408: and inventory_location_id = p_locator_id;

Line 406: , last_update_login = FND_GLOBAL.LOGIN_ID

402: update mtl_item_locations
403: set status_id = p_loc_status_id
404: , last_updated_by = FND_GLOBAL.USER_ID
405: , last_update_date = SYSDATE
406: , last_update_login = FND_GLOBAL.LOGIN_ID
407: where organization_id = p_organization_id
408: and inventory_location_id = p_locator_id;
409:
410: l_status_rec.zone_code := p_sub_code;

Line 426: , last_updated_by = FND_GLOBAL.USER_ID

422: END IF;
423: if p_lot_status_id >0 then
424: update mtl_lot_numbers
425: set status_id = p_lot_status_id
426: , last_updated_by = FND_GLOBAL.USER_ID
427: , last_update_date = SYSDATE
428: , last_update_login = FND_GLOBAL.LOGIN_ID
429: where organization_id = p_organization_id
430: and inventory_item_id = p_inventory_item_id

Line 428: , last_update_login = FND_GLOBAL.LOGIN_ID

424: update mtl_lot_numbers
425: set status_id = p_lot_status_id
426: , last_updated_by = FND_GLOBAL.USER_ID
427: , last_update_date = SYSDATE
428: , last_update_login = FND_GLOBAL.LOGIN_ID
429: where organization_id = p_organization_id
430: and inventory_item_id = p_inventory_item_id
431: and lot_number BETWEEN p_from_lot_number and p_to_lot_number ;
432:

Line 456: , last_updated_by = FND_GLOBAL.USER_ID

452: END IF;
453: if p_serial_status_id >0 then
454: update mtl_serial_numbers
455: set status_id = p_serial_status_id
456: , last_updated_by = FND_GLOBAL.USER_ID
457: , last_update_date = SYSDATE
458: , last_update_login = FND_GLOBAL.LOGIN_ID
459: where current_organization_id = p_organization_id
460: and inventory_item_id = p_inventory_item_id

Line 458: , last_update_login = FND_GLOBAL.LOGIN_ID

454: update mtl_serial_numbers
455: set status_id = p_serial_status_id
456: , last_updated_by = FND_GLOBAL.USER_ID
457: , last_update_date = SYSDATE
458: , last_update_login = FND_GLOBAL.LOGIN_ID
459: where current_organization_id = p_organization_id
460: and inventory_item_id = p_inventory_item_id
461: and serial_number BETWEEN p_from_SN AND p_to_SN;
462:

Line 527: , last_updated_by = FND_GLOBAL.USER_ID

523: END IF;
524: IF(l_serial_controlled = 0)THEN
525: UPDATE mtl_onhand_quantities_detail
526: SET status_id = p_onhand_status_id
527: , last_updated_by = FND_GLOBAL.USER_ID
528: , last_update_date = SYSDATE
529: , last_update_login = FND_GLOBAL.LOGIN_ID
530: WHERE inventory_item_id = l_wlc_cur.inventory_item_id
531: AND organization_id = p_organization_id

Line 529: , last_update_login = FND_GLOBAL.LOGIN_ID

525: UPDATE mtl_onhand_quantities_detail
526: SET status_id = p_onhand_status_id
527: , last_updated_by = FND_GLOBAL.USER_ID
528: , last_update_date = SYSDATE
529: , last_update_login = FND_GLOBAL.LOGIN_ID
530: WHERE inventory_item_id = l_wlc_cur.inventory_item_id
531: AND organization_id = p_organization_id
532: AND subinventory_code = Nvl(p_sub_code,'@@@@')
533: AND locator_id = Nvl(p_locator_id ,-9999)

Line 539: , last_updated_by = FND_GLOBAL.USER_ID

535: AND lpn_id = l_wlc_cur.parent_lpn_id;
536: ELSIF(l_serial_status_enabled = 1)THEN
537: UPDATE mtl_serial_numbers
538: set status_id = p_onhand_status_id
539: , last_updated_by = FND_GLOBAL.USER_ID
540: , last_update_date = SYSDATE
541: , last_update_login = FND_GLOBAL.LOGIN_ID
542: WHERE inventory_item_id = l_wlc_cur.inventory_item_id
543: AND current_organization_id = p_organization_id

Line 541: , last_update_login = FND_GLOBAL.LOGIN_ID

537: UPDATE mtl_serial_numbers
538: set status_id = p_onhand_status_id
539: , last_updated_by = FND_GLOBAL.USER_ID
540: , last_update_date = SYSDATE
541: , last_update_login = FND_GLOBAL.LOGIN_ID
542: WHERE inventory_item_id = l_wlc_cur.inventory_item_id
543: AND current_organization_id = p_organization_id
544: AND current_subinventory_code = Nvl(p_sub_code,'@@@@')
545: AND current_locator_id = Nvl(p_locator_id ,-9999)

Line 576: , last_updated_by = FND_GLOBAL.USER_ID

572: END IF;
573:
574: update mtl_serial_numbers
575: set status_id = p_onhand_status_id
576: , last_updated_by = FND_GLOBAL.USER_ID
577: , last_update_date = SYSDATE
578: , last_update_login = FND_GLOBAL.LOGIN_ID
579: where lpn_id = p_lpn_id
580: AND current_organization_id = p_organization_id

Line 578: , last_update_login = FND_GLOBAL.LOGIN_ID

574: update mtl_serial_numbers
575: set status_id = p_onhand_status_id
576: , last_updated_by = FND_GLOBAL.USER_ID
577: , last_update_date = SYSDATE
578: , last_update_login = FND_GLOBAL.LOGIN_ID
579: where lpn_id = p_lpn_id
580: AND current_organization_id = p_organization_id
581: AND inventory_item_id = p_inventory_item_id
582: AND serial_number BETWEEN p_from_SN AND p_to_SN

Line 616: , last_updated_by = FND_GLOBAL.USER_ID

612: FORALL j in rowid_list.first .. rowid_list.last
613:
614: update mtl_onhand_quantities_detail
615: set status_id = p_onhand_status_id
616: , last_updated_by = FND_GLOBAL.USER_ID
617: , last_update_date = SYSDATE
618: , last_update_login = FND_GLOBAL.LOGIN_ID
619: where ROWID = rowid_list(j);
620: -- Modified the where clause in the above update as it is not required for the bug # 6633612

Line 618: , last_update_login = FND_GLOBAL.LOGIN_ID

614: update mtl_onhand_quantities_detail
615: set status_id = p_onhand_status_id
616: , last_updated_by = FND_GLOBAL.USER_ID
617: , last_update_date = SYSDATE
618: , last_update_login = FND_GLOBAL.LOGIN_ID
619: where ROWID = rowid_list(j);
620: -- Modified the where clause in the above update as it is not required for the bug # 6633612
621: COMMIT;
622: CLOSE cur_onhand;

Line 638: , last_updated_by = FND_GLOBAL.USER_ID

634: FORALL j in rowid_list1.first .. rowid_list1.last
635:
636: update mtl_serial_numbers
637: set status_id = p_onhand_status_id
638: , last_updated_by = FND_GLOBAL.USER_ID
639: , last_update_date = SYSDATE
640: , last_update_login = FND_GLOBAL.LOGIN_ID
641: where ROWID = rowid_list1(j);
642: COMMIT;

Line 640: , last_update_login = FND_GLOBAL.LOGIN_ID

636: update mtl_serial_numbers
637: set status_id = p_onhand_status_id
638: , last_updated_by = FND_GLOBAL.USER_ID
639: , last_update_date = SYSDATE
640: , last_update_login = FND_GLOBAL.LOGIN_ID
641: where ROWID = rowid_list1(j);
642: COMMIT;
643: CLOSE cur_onhserial;
644: END IF;