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_MATERIAL_STATUS_PKG dependencies on MTL_SECONDARY_INVENTORIES

Line 17: from mtl_secondary_inventories

13: select 1
14: into count_assigned
15: from dual
16: where exists (select 1
17: from mtl_secondary_inventories
18: where status_id = p_status_id);
19:
20: if count_assigned >0 then
21: return TRUE;

Line 101: FROM MTL_SECONDARY_INVENTORIES

97: l_status_id NUMBER;
98: BEGIN
99: SELECT default_loc_status_id
100: INTO l_status_id
101: FROM MTL_SECONDARY_INVENTORIES
102: WHERE organization_id = p_organization_id
103: AND secondary_inventory_name = p_sub_code;
104: return l_status_id;
105: exception

Line 543: p_organization_id mtl_secondary_inventories.organization_id%TYPE,

539: p_old_status_id mtl_material_statuses.status_id%TYPE,
540: p_new_status_id mtl_material_statuses.status_id%TYPE ,
541: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
542: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
543: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
544: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE
545: )RETURN BOOLEAN AS
546:
547: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE := NULL;

Line 585: p_organization_id mtl_secondary_inventories.organization_id%TYPE,

581: p_old_status_id mtl_material_statuses.status_id%TYPE,
582: p_new_status_id mtl_material_statuses.status_id%TYPE ,
583: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
584: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
585: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
586: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
587: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE /* bug 6866429 */
588: )RETURN BOOLEAN AS
589: CURSOR cur_mt_status (cp_old_status_id mtl_material_statuses.status_code%TYPE,

Line 766: ,p_org_id MTL_SECONDARY_INVENTORIES.ORGANIZATION_ID%TYPE

762: END validate_mtstatus;
763:
764: PROCEDURE SET_MS_FLAGS(
765: p_status_id MTL_MATERIAL_STATUSES.STATUS_ID%TYPE
766: ,p_org_id MTL_SECONDARY_INVENTORIES.ORGANIZATION_ID%TYPE
767: ,p_inventory_item_id MTL_LOT_NUMBERS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
768: ,p_secondary_inventory_name MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE DEFAULT NULL
769: ,p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE DEFAULT NULL
770: ,p_inventory_location_id MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID%TYPE DEFAULT NULL

Line 768: ,p_secondary_inventory_name MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE DEFAULT NULL

764: PROCEDURE SET_MS_FLAGS(
765: p_status_id MTL_MATERIAL_STATUSES.STATUS_ID%TYPE
766: ,p_org_id MTL_SECONDARY_INVENTORIES.ORGANIZATION_ID%TYPE
767: ,p_inventory_item_id MTL_LOT_NUMBERS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
768: ,p_secondary_inventory_name MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE DEFAULT NULL
769: ,p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE DEFAULT NULL
770: ,p_inventory_location_id MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID%TYPE DEFAULT NULL
771: ,p_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE DEFAULT NULL
772: ) AS

Line 810: UPDATE mtl_secondary_inventories SET inventory_atp_code =rec_ms.inventory_atp_code,

806: reservable_type =rec_ms.availability_type
807: WHERE organization_id = p_org_id
808: AND inventory_location_id = p_inventory_location_id;
809: ELSIF p_secondary_inventory_name IS NOT NULL THEN
810: UPDATE mtl_secondary_inventories SET inventory_atp_code =rec_ms.inventory_atp_code,
811: availability_type =rec_ms.reservable_type,
812: reservable_type =rec_ms.availability_type
813: WHERE organization_id = p_org_id
814: AND secondary_inventory_name =p_secondary_inventory_name;