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 423: , last_updated_by = FND_GLOBAL.USER_ID

419:
420: FORALL j in rowid_list.first .. rowid_list.last
421: update mtl_onhand_quantities_detail
422: set status_id = p_status_id
423: , last_updated_by = FND_GLOBAL.USER_ID
424: , last_update_date = SYSDATE
425: , last_update_login = FND_GLOBAL.LOGIN_ID
426: where ROWID = rowid_list(j);
427: CLOSE cur_onhand;

Line 425: , last_update_login = FND_GLOBAL.LOGIN_ID

421: update mtl_onhand_quantities_detail
422: set status_id = p_status_id
423: , last_updated_by = FND_GLOBAL.USER_ID
424: , last_update_date = SYSDATE
425: , last_update_login = FND_GLOBAL.LOGIN_ID
426: where ROWID = rowid_list(j);
427: CLOSE cur_onhand;
428:
429: mdebug(' update executed in sql: Onhand');

Line 444: , last_updated_by = FND_GLOBAL.USER_ID

440: FORALL j in rowid_list1.first .. rowid_list1.last
441:
442: update mtl_serial_numbers
443: set status_id = p_status_id
444: , last_updated_by = FND_GLOBAL.USER_ID
445: , last_update_date = SYSDATE
446: , last_update_login = FND_GLOBAL.LOGIN_ID
447: where ROWID = rowid_list1(j);
448: CLOSE cur_onhserial;

Line 446: , last_update_login = FND_GLOBAL.LOGIN_ID

442: update mtl_serial_numbers
443: set status_id = p_status_id
444: , last_updated_by = FND_GLOBAL.USER_ID
445: , last_update_date = SYSDATE
446: , last_update_login = FND_GLOBAL.LOGIN_ID
447: where ROWID = rowid_list1(j);
448: CLOSE cur_onhserial;
449:
450: END IF;

Line 465: , last_updated_by = FND_GLOBAL.USER_ID

461:
462: FORALL j in rowid_list.first .. rowid_list.last
463: update mtl_secondary_inventories
464: set status_id = p_status_id
465: , last_updated_by = FND_GLOBAL.USER_ID
466: , last_update_date = SYSDATE
467: , last_update_login = FND_GLOBAL.LOGIN_ID
468: where ROWID = rowid_list(j);
469: CLOSE cur_Subinv;

Line 467: , last_update_login = FND_GLOBAL.LOGIN_ID

463: update mtl_secondary_inventories
464: set status_id = p_status_id
465: , last_updated_by = FND_GLOBAL.USER_ID
466: , last_update_date = SYSDATE
467: , last_update_login = FND_GLOBAL.LOGIN_ID
468: where ROWID = rowid_list(j);
469: CLOSE cur_Subinv;
470:
471: mdebug(' update executed in sql: Onhand');

Line 488: , last_updated_by = FND_GLOBAL.USER_ID

484:
485: FORALL j in rowid_list.first .. rowid_list.last
486: update mtl_item_locations
487: set status_id = p_status_id
488: , last_updated_by = FND_GLOBAL.USER_ID
489: , last_update_date = SYSDATE
490: , last_update_login = FND_GLOBAL.LOGIN_ID
491: where ROWID = rowid_list(j);
492: CLOSE cur_Loc;

Line 490: , last_update_login = FND_GLOBAL.LOGIN_ID

486: update mtl_item_locations
487: set status_id = p_status_id
488: , last_updated_by = FND_GLOBAL.USER_ID
489: , last_update_date = SYSDATE
490: , last_update_login = FND_GLOBAL.LOGIN_ID
491: where ROWID = rowid_list(j);
492: CLOSE cur_Loc;
493:
494: mdebug(' update executed in sql: Onhand');

Line 509: , last_updated_by = FND_GLOBAL.USER_ID

505:
506: FORALL j in rowid_list.first .. rowid_list.last
507: update mtl_lot_numbers
508: set status_id = p_status_id
509: , last_updated_by = FND_GLOBAL.USER_ID
510: , last_update_date = SYSDATE
511: , last_update_login = FND_GLOBAL.LOGIN_ID
512: where ROWID = rowid_list(j);
513: CLOSE cur_Lot;

Line 511: , last_update_login = FND_GLOBAL.LOGIN_ID

507: update mtl_lot_numbers
508: set status_id = p_status_id
509: , last_updated_by = FND_GLOBAL.USER_ID
510: , last_update_date = SYSDATE
511: , last_update_login = FND_GLOBAL.LOGIN_ID
512: where ROWID = rowid_list(j);
513: CLOSE cur_Lot;
514:
515: mdebug(' update executed in sql: Onhand');

Line 532: , last_updated_by = FND_GLOBAL.USER_ID

528:
529: FORALL j in rowid_list.first .. rowid_list.last
530: update mtl_serial_numbers
531: set status_id = p_status_id
532: , last_updated_by = FND_GLOBAL.USER_ID
533: , last_update_date = SYSDATE
534: , last_update_login = FND_GLOBAL.LOGIN_ID
535: where ROWID = rowid_list(j);
536: CLOSE cur_Serial;

Line 534: , last_update_login = FND_GLOBAL.LOGIN_ID

530: update mtl_serial_numbers
531: set status_id = p_status_id
532: , last_updated_by = FND_GLOBAL.USER_ID
533: , last_update_date = SYSDATE
534: , last_update_login = FND_GLOBAL.LOGIN_ID
535: where ROWID = rowid_list(j);
536: CLOSE cur_Serial;
537:
538: mdebug(' update executed in sql: Onhand');

Line 797: , last_updated_by = FND_GLOBAL.USER_ID

793:
794: IF p_pending_status = 0 THEN --ERES Deferred
795: update mtl_secondary_inventories
796: set status_id = p_sub_status_id
797: , last_updated_by = FND_GLOBAL.USER_ID
798: , last_update_date = SYSDATE
799: , last_update_login = FND_GLOBAL.LOGIN_ID
800: where organization_id = p_organization_id
801: and secondary_inventory_name = p_sub_code;

Line 799: , last_update_login = FND_GLOBAL.LOGIN_ID

795: update mtl_secondary_inventories
796: set status_id = p_sub_status_id
797: , last_updated_by = FND_GLOBAL.USER_ID
798: , last_update_date = SYSDATE
799: , last_update_login = FND_GLOBAL.LOGIN_ID
800: where organization_id = p_organization_id
801: and secondary_inventory_name = p_sub_code;
802: END IF;
803: l_status_rec.zone_code := p_sub_code;

Line 851: , last_updated_by = FND_GLOBAL.USER_ID

847:
848: IF p_pending_status = 0 THEN --ERES Deferred
849: update mtl_item_locations
850: set status_id = p_loc_status_id
851: , last_updated_by = FND_GLOBAL.USER_ID
852: , last_update_date = SYSDATE
853: , last_update_login = FND_GLOBAL.LOGIN_ID
854: where organization_id = p_organization_id
855: and inventory_location_id = p_locator_id;

Line 853: , last_update_login = FND_GLOBAL.LOGIN_ID

849: update mtl_item_locations
850: set status_id = p_loc_status_id
851: , last_updated_by = FND_GLOBAL.USER_ID
852: , last_update_date = SYSDATE
853: , last_update_login = FND_GLOBAL.LOGIN_ID
854: where organization_id = p_organization_id
855: and inventory_location_id = p_locator_id;
856: END IF;
857: l_status_rec.zone_code := p_sub_code;

Line 910: , last_updated_by = FND_GLOBAL.USER_ID

906:
907: IF p_pending_status = 0 THEN --ERES Deferred
908: update mtl_lot_numbers
909: set status_id = p_lot_status_id
910: , last_updated_by = FND_GLOBAL.USER_ID
911: , last_update_date = SYSDATE
912: , last_update_login = FND_GLOBAL.LOGIN_ID
913: where organization_id = p_organization_id
914: and inventory_item_id = p_inventory_item_id

Line 912: , last_update_login = FND_GLOBAL.LOGIN_ID

908: update mtl_lot_numbers
909: set status_id = p_lot_status_id
910: , last_updated_by = FND_GLOBAL.USER_ID
911: , last_update_date = SYSDATE
912: , last_update_login = FND_GLOBAL.LOGIN_ID
913: where organization_id = p_organization_id
914: and inventory_item_id = p_inventory_item_id
915: and lot_number BETWEEN p_from_lot_number and p_to_lot_number ;
916: END IF;

Line 977: , last_updated_by = FND_GLOBAL.USER_ID

973:
974: IF p_pending_status = 0 THEN --ERES Deferred
975: update mtl_serial_numbers
976: set status_id = p_serial_status_id
977: , last_updated_by = FND_GLOBAL.USER_ID
978: , last_update_date = SYSDATE
979: , last_update_login = FND_GLOBAL.LOGIN_ID
980: where current_organization_id = p_organization_id
981: and inventory_item_id = p_inventory_item_id

Line 979: , last_update_login = FND_GLOBAL.LOGIN_ID

975: update mtl_serial_numbers
976: set status_id = p_serial_status_id
977: , last_updated_by = FND_GLOBAL.USER_ID
978: , last_update_date = SYSDATE
979: , last_update_login = FND_GLOBAL.LOGIN_ID
980: where current_organization_id = p_organization_id
981: and inventory_item_id = p_inventory_item_id
982: and serial_number BETWEEN p_from_SN AND p_to_SN;
983: END If;

Line 1050: , last_updated_by = FND_GLOBAL.USER_ID

1046: END IF;
1047: IF(l_serial_controlled = 0)THEN
1048: UPDATE mtl_onhand_quantities_detail
1049: SET status_id = p_onhand_status_id
1050: , last_updated_by = FND_GLOBAL.USER_ID
1051: , last_update_date = SYSDATE
1052: , last_update_login = FND_GLOBAL.LOGIN_ID
1053: WHERE inventory_item_id = l_wlc_cur.inventory_item_id
1054: AND organization_id = p_organization_id

Line 1052: , last_update_login = FND_GLOBAL.LOGIN_ID

1048: UPDATE mtl_onhand_quantities_detail
1049: SET status_id = p_onhand_status_id
1050: , last_updated_by = FND_GLOBAL.USER_ID
1051: , last_update_date = SYSDATE
1052: , last_update_login = FND_GLOBAL.LOGIN_ID
1053: WHERE inventory_item_id = l_wlc_cur.inventory_item_id
1054: AND organization_id = p_organization_id
1055: AND subinventory_code = Nvl(p_sub_code,'@@@@')
1056: AND locator_id = Nvl(p_locator_id ,-9999)

Line 1062: , last_updated_by = FND_GLOBAL.USER_ID

1058: AND lpn_id = l_wlc_cur.parent_lpn_id;
1059: ELSIF(l_serial_status_enabled = 1)THEN
1060: UPDATE mtl_serial_numbers
1061: set status_id = p_onhand_status_id
1062: , last_updated_by = FND_GLOBAL.USER_ID
1063: , last_update_date = SYSDATE
1064: , last_update_login = FND_GLOBAL.LOGIN_ID
1065: WHERE inventory_item_id = l_wlc_cur.inventory_item_id
1066: AND current_organization_id = p_organization_id

Line 1064: , last_update_login = FND_GLOBAL.LOGIN_ID

1060: UPDATE mtl_serial_numbers
1061: set status_id = p_onhand_status_id
1062: , last_updated_by = FND_GLOBAL.USER_ID
1063: , last_update_date = SYSDATE
1064: , last_update_login = FND_GLOBAL.LOGIN_ID
1065: WHERE inventory_item_id = l_wlc_cur.inventory_item_id
1066: AND current_organization_id = p_organization_id
1067: AND current_subinventory_code = Nvl(p_sub_code,'@@@@')
1068: AND current_locator_id = Nvl(p_locator_id ,-9999)

Line 1099: , last_updated_by = FND_GLOBAL.USER_ID

1095: END IF;
1096:
1097: update mtl_serial_numbers
1098: set status_id = p_onhand_status_id
1099: , last_updated_by = FND_GLOBAL.USER_ID
1100: , last_update_date = SYSDATE
1101: , last_update_login = FND_GLOBAL.LOGIN_ID
1102: where lpn_id = p_lpn_id
1103: AND current_organization_id = p_organization_id

Line 1101: , last_update_login = FND_GLOBAL.LOGIN_ID

1097: update mtl_serial_numbers
1098: set status_id = p_onhand_status_id
1099: , last_updated_by = FND_GLOBAL.USER_ID
1100: , last_update_date = SYSDATE
1101: , last_update_login = FND_GLOBAL.LOGIN_ID
1102: where lpn_id = p_lpn_id
1103: AND current_organization_id = p_organization_id
1104: AND inventory_item_id = p_inventory_item_id
1105: AND serial_number BETWEEN p_from_SN AND p_to_SN

Line 1262: , last_updated_by = FND_GLOBAL.USER_ID

1258: FORALL j in rowid_list.first .. rowid_list.last
1259:
1260: update mtl_onhand_quantities_detail
1261: set status_id = p_onhand_status_id
1262: , last_updated_by = FND_GLOBAL.USER_ID
1263: , last_update_date = SYSDATE
1264: , last_update_login = FND_GLOBAL.LOGIN_ID
1265: where ROWID = rowid_list(j);
1266: -- Modified the where clause in the above update as it is not required for the bug # 6633612

Line 1264: , last_update_login = FND_GLOBAL.LOGIN_ID

1260: update mtl_onhand_quantities_detail
1261: set status_id = p_onhand_status_id
1262: , last_updated_by = FND_GLOBAL.USER_ID
1263: , last_update_date = SYSDATE
1264: , last_update_login = FND_GLOBAL.LOGIN_ID
1265: where ROWID = rowid_list(j);
1266: -- Modified the where clause in the above update as it is not required for the bug # 6633612
1267: --COMMIT; Bug#11826279, MTL_GRADE_STATUS_ERES_GTM getting deleted in the same session.
1268: CLOSE cur_onhand;

Line 1284: , last_updated_by = FND_GLOBAL.USER_ID

1280: FORALL j in rowid_list1.first .. rowid_list1.last
1281:
1282: update mtl_serial_numbers
1283: set status_id = p_onhand_status_id
1284: , last_updated_by = FND_GLOBAL.USER_ID
1285: , last_update_date = SYSDATE
1286: , last_update_login = FND_GLOBAL.LOGIN_ID
1287: where ROWID = rowid_list1(j);
1288: --COMMIT; Bug#11826279, MTL_GRADE_STATUS_ERES_GTM getting deleted in the same session.

Line 1286: , last_update_login = FND_GLOBAL.LOGIN_ID

1282: update mtl_serial_numbers
1283: set status_id = p_onhand_status_id
1284: , last_updated_by = FND_GLOBAL.USER_ID
1285: , last_update_date = SYSDATE
1286: , last_update_login = FND_GLOBAL.LOGIN_ID
1287: where ROWID = rowid_list1(j);
1288: --COMMIT; Bug#11826279, MTL_GRADE_STATUS_ERES_GTM getting deleted in the same session.
1289: CLOSE cur_onhserial;
1290: END IF;