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 575: p_old_status_id mtl_material_statuses.status_id%TYPE,

571: END Insert_status_history;
572:
573: /* bug 11806801 */
574: FUNCTION validate_mtstatus2(
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,

Line 576: p_new_status_id mtl_material_statuses.status_id%TYPE ,

572:
573: /* bug 11806801 */
574: FUNCTION validate_mtstatus2(
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,

Line 609: p_old_status_id mtl_material_statuses.status_id%TYPE,

605: END;
606:
607:
608: FUNCTION validate_mtstatus(
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,

Line 610: p_new_status_id mtl_material_statuses.status_id%TYPE ,

606:
607:
608: FUNCTION validate_mtstatus(
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

Line 649: p_old_status_id mtl_material_statuses.status_id%TYPE,

645:
646:
647: /* Bug 6837479 */
648: FUNCTION validate_mtstatus(
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,

Line 650: p_new_status_id mtl_material_statuses.status_id%TYPE ,

646:
647: /* Bug 6837479 */
648: FUNCTION validate_mtstatus(
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,

Line 716: p_old_status_id mtl_material_statuses.status_id%TYPE,

712: * reservations
713: */
714: --INVCONV kkillams
715: FUNCTION validate_mtstatus(
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,

Line 717: p_new_status_id mtl_material_statuses.status_id%TYPE ,

713: */
714: --INVCONV kkillams
715: FUNCTION validate_mtstatus(
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,

Line 726: CURSOR cur_mt_status (cp_old_status_id mtl_material_statuses.status_code%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
725: )RETURN BOOLEAN AS
726: CURSOR cur_mt_status (cp_old_status_id mtl_material_statuses.status_code%TYPE,
727: cp_new_status_id mtl_material_statuses.status_code%TYPE) IS
728: SELECT 1 FROM mtl_material_statuses mts1,
729: mtl_material_statuses mts2
730: WHERE cp_old_status_id <> cp_new_status_id

Line 727: cp_new_status_id mtl_material_statuses.status_code%TYPE) IS

723: p_dummy_param NUMBER,
724: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066
725: )RETURN BOOLEAN AS
726: CURSOR cur_mt_status (cp_old_status_id mtl_material_statuses.status_code%TYPE,
727: cp_new_status_id mtl_material_statuses.status_code%TYPE) IS
728: SELECT 1 FROM mtl_material_statuses mts1,
729: mtl_material_statuses mts2
730: WHERE cp_old_status_id <> cp_new_status_id
731: AND mts1.status_id = cp_old_status_id

Line 728: SELECT 1 FROM mtl_material_statuses mts1,

724: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066
725: )RETURN BOOLEAN AS
726: CURSOR cur_mt_status (cp_old_status_id mtl_material_statuses.status_code%TYPE,
727: cp_new_status_id mtl_material_statuses.status_code%TYPE) IS
728: SELECT 1 FROM mtl_material_statuses mts1,
729: mtl_material_statuses mts2
730: WHERE cp_old_status_id <> cp_new_status_id
731: AND mts1.status_id = cp_old_status_id
732: AND mts1.reservable_type = 1

Line 729: mtl_material_statuses mts2

725: )RETURN BOOLEAN AS
726: CURSOR cur_mt_status (cp_old_status_id mtl_material_statuses.status_code%TYPE,
727: cp_new_status_id mtl_material_statuses.status_code%TYPE) IS
728: SELECT 1 FROM mtl_material_statuses mts1,
729: mtl_material_statuses mts2
730: WHERE cp_old_status_id <> cp_new_status_id
731: AND mts1.status_id = cp_old_status_id
732: AND mts1.reservable_type = 1
733: AND mts2.status_id = cp_new_status_id

Line 968: p_status_id MTL_MATERIAL_STATUSES.STATUS_ID%TYPE

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

Line 978: ,availability_type FROM mtl_material_statuses

974: ,p_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE DEFAULT NULL
975: ) AS
976: CURSOR cur_ms IS SELECT inventory_atp_code
977: ,reservable_type
978: ,availability_type FROM mtl_material_statuses
979: WHERE status_id = p_status_id;
980: rec_ms cur_ms%ROWTYPE;
981: BEGIN
982: OPEN cur_ms;