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_MATERIAL_STATUSES

Line 539: p_old_status_id mtl_material_statuses.status_id%TYPE,

535:
536: END Insert_status_history;
537:
538: FUNCTION validate_mtstatus(
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,

Line 540: p_new_status_id mtl_material_statuses.status_id%TYPE ,

536: END Insert_status_history;
537:
538: FUNCTION validate_mtstatus(
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

Line 581: p_old_status_id mtl_material_statuses.status_id%TYPE,

577: * reservations
578: */
579: --INVCONV kkillams
580: FUNCTION validate_mtstatus(
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,

Line 582: p_new_status_id mtl_material_statuses.status_id%TYPE ,

578: */
579: --INVCONV kkillams
580: FUNCTION validate_mtstatus(
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,

Line 589: CURSOR cur_mt_status (cp_old_status_id mtl_material_statuses.status_code%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,
590: cp_new_status_id mtl_material_statuses.status_code%TYPE) IS
591: SELECT 1 FROM mtl_material_statuses mts1,
592: mtl_material_statuses mts2
593: WHERE cp_old_status_id <> cp_new_status_id

Line 590: cp_new_status_id mtl_material_statuses.status_code%TYPE) IS

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,
590: cp_new_status_id mtl_material_statuses.status_code%TYPE) IS
591: SELECT 1 FROM mtl_material_statuses mts1,
592: mtl_material_statuses mts2
593: WHERE cp_old_status_id <> cp_new_status_id
594: AND mts1.status_id = cp_old_status_id

Line 591: SELECT 1 FROM mtl_material_statuses mts1,

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,
590: cp_new_status_id mtl_material_statuses.status_code%TYPE) IS
591: SELECT 1 FROM mtl_material_statuses mts1,
592: mtl_material_statuses mts2
593: WHERE cp_old_status_id <> cp_new_status_id
594: AND mts1.status_id = cp_old_status_id
595: AND mts1.reservable_type = 1

Line 592: mtl_material_statuses mts2

588: )RETURN BOOLEAN AS
589: CURSOR cur_mt_status (cp_old_status_id mtl_material_statuses.status_code%TYPE,
590: cp_new_status_id mtl_material_statuses.status_code%TYPE) IS
591: SELECT 1 FROM mtl_material_statuses mts1,
592: mtl_material_statuses mts2
593: WHERE cp_old_status_id <> cp_new_status_id
594: AND mts1.status_id = cp_old_status_id
595: AND mts1.reservable_type = 1
596: AND mts2.status_id = cp_new_status_id

Line 765: p_status_id MTL_MATERIAL_STATUSES.STATUS_ID%TYPE

761:
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

Line 775: ,availability_type FROM mtl_material_statuses

771: ,p_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE DEFAULT NULL
772: ) AS
773: CURSOR cur_ms IS SELECT inventory_atp_code
774: ,reservable_type
775: ,availability_type FROM mtl_material_statuses
776: WHERE status_id = p_status_id;
777: rec_ms cur_ms%ROWTYPE;
778: BEGIN
779: OPEN cur_ms;