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 579: p_organization_id mtl_secondary_inventories.organization_id%TYPE,

575: p_old_status_id mtl_material_statuses.status_id%TYPE,
576: p_new_status_id mtl_material_statuses.status_id%TYPE ,
577: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
578: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
579: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
580: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
581: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE
582: )RETURN CHAR AS
583:

Line 613: p_organization_id mtl_secondary_inventories.organization_id%TYPE,

609: p_old_status_id mtl_material_statuses.status_id%TYPE,
610: p_new_status_id mtl_material_statuses.status_id%TYPE ,
611: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
612: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
613: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
614: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE
615: )RETURN BOOLEAN AS
616:
617: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE := NULL;

Line 653: p_organization_id mtl_secondary_inventories.organization_id%TYPE,

649: p_old_status_id mtl_material_statuses.status_id%TYPE,
650: p_new_status_id mtl_material_statuses.status_id%TYPE ,
651: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
652: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
653: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
654: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
655: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE,
656: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066
657: )RETURN BOOLEAN AS

Line 720: p_organization_id mtl_secondary_inventories.organization_id%TYPE,

716: p_old_status_id mtl_material_statuses.status_id%TYPE,
717: p_new_status_id mtl_material_statuses.status_id%TYPE ,
718: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
719: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
720: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
721: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
722: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE, /* bug 6837479 */
723: p_dummy_param NUMBER,
724: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066

Line 969: ,p_org_id MTL_SECONDARY_INVENTORIES.ORGANIZATION_ID%TYPE

965: END validate_mtstatus;
966:
967: PROCEDURE SET_MS_FLAGS(
968: p_status_id MTL_MATERIAL_STATUSES.STATUS_ID%TYPE
969: ,p_org_id MTL_SECONDARY_INVENTORIES.ORGANIZATION_ID%TYPE
970: ,p_inventory_item_id MTL_LOT_NUMBERS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
971: ,p_secondary_inventory_name MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE DEFAULT NULL
972: ,p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE DEFAULT NULL
973: ,p_inventory_location_id MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID%TYPE DEFAULT NULL

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

967: PROCEDURE SET_MS_FLAGS(
968: p_status_id MTL_MATERIAL_STATUSES.STATUS_ID%TYPE
969: ,p_org_id MTL_SECONDARY_INVENTORIES.ORGANIZATION_ID%TYPE
970: ,p_inventory_item_id MTL_LOT_NUMBERS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
971: ,p_secondary_inventory_name MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE DEFAULT NULL
972: ,p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE DEFAULT NULL
973: ,p_inventory_location_id MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID%TYPE DEFAULT NULL
974: ,p_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE DEFAULT NULL
975: ) AS

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

1009: reservable_type =rec_ms.availability_type
1010: WHERE organization_id = p_org_id
1011: AND inventory_location_id = p_inventory_location_id;
1012: ELSIF p_secondary_inventory_name IS NOT NULL THEN
1013: UPDATE mtl_secondary_inventories SET inventory_atp_code =rec_ms.inventory_atp_code,
1014: availability_type =rec_ms.reservable_type,
1015: reservable_type =rec_ms.availability_type
1016: WHERE organization_id = p_org_id
1017: AND secondary_inventory_name =p_secondary_inventory_name;