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_LOT_APIS dependencies on INV_MATERIAL_STATUS_GRP

Line 681: inv_material_status_grp.is_status_applicable */

677: END Set_Msi_Default_Attr ;
678:
679: /*Added p_subinventory_code , p_locator_id in below procedure for Onhand status support
680: Also passed p_subinventory_code,p_locator_id in
681: inv_material_status_grp.is_status_applicable */
682: PROCEDURE get_parent_lov(x_lot_num_lov OUT NOCOPY t_genref, p_wms_installed IN VARCHAR2, p_organization_id IN NUMBER, p_txn_type_id IN NUMBER, p_inventory_item_id IN VARCHAR2, p_lot_number IN VARCHAR2, p_project_id IN NUMBER, p_task_id IN NUMBER ,
683: p_subinventory_code IN VARCHAR2,p_locator_id IN NUMBER ) IS
684: l_inventory_item_id VARCHAR2(100);
685: BEGIN

Line 711: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,

707: AND mln.inventory_item_id = msik.inventory_item_id
708: AND mln.inventory_item_id LIKE l_inventory_item_id
709: AND msik.lot_split_enabled = 'Y'
710: AND mln.lot_number = p_lot_number
711: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,
712: p_organization_id, msik.inventory_item_id, p_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'
713: UNION
714: SELECT mln.lot_number lot_number
715: , mln.inventory_item_id

Line 746: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,

742: AND mln.inventory_item_id = msik.inventory_item_id
743: AND mln.inventory_item_id LIKE l_inventory_item_id
744: AND msik.lot_split_enabled = 'Y'
745: AND mln.lot_number = p_lot_number
746: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,
747: p_organization_id, msik.inventory_item_id, p_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'
748: UNION
749: SELECT nvl(mln.parent_lot_number,mln.lot_number) lot_number
750: , mln.inventory_item_id

Line 796: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id,

792: AND mln.inventory_item_id = msik.inventory_item_id
793: AND mln.inventory_item_id LIKE l_inventory_item_id
794: AND msik.lot_merge_enabled = 'Y'
795: AND mln.lot_number LIKE (p_lot_number)
796: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id,
797: msik.inventory_item_id, p_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'
798: UNION ALL
799: SELECT DISTINCT moq.lot_number
800: , moq.inventory_item_id

Line 824: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id,

820: AND mln.inventory_item_id = msik.inventory_item_id
821: AND mln.inventory_item_id LIKE l_inventory_item_id
822: AND msik.lot_merge_enabled = 'Y'
823: AND mln.lot_number LIKE (p_lot_number)
824: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id,
825: msik.inventory_item_id, p_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'
826: ORDER BY 1, concatenated_segments;
827: ELSE
828: OPEN x_lot_num_lov FOR

Line 845: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,

841: AND mln.inventory_item_id = msik.inventory_item_id
842: AND mln.inventory_item_id LIKE l_inventory_item_id
843: AND msik.lot_merge_enabled = 'Y'
844: AND mln.lot_number LIKE (p_lot_number)
845: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled,
846: p_organization_id, msik.inventory_item_id, p_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'
847: UNION ALL
848: SELECT mln.lot_number lot_number
849: , mln.inventory_item_id

Line 863: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id, msik.inventory_item_id,

859: AND mln.inventory_item_id = msik.inventory_item_id
860: AND mln.inventory_item_id LIKE l_inventory_item_id
861: AND msik.lot_merge_enabled = 'Y'
862: AND mln.lot_number LIKE (p_lot_number)
863: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id, msik.inventory_item_id,
864: p_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'
865: ORDER BY lot_number, concatenated_segments;
866: END IF;
867: ELSE -- for Lot Translate

Line 885: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id, msik.inventory_item_id,

881: AND mln.inventory_item_id = msik.inventory_item_id
882: AND msik.lot_control_code = 2
883: AND mln.inventory_item_id LIKE l_inventory_item_id
884: AND mln.lot_number LIKE (p_lot_number)
885: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_txn_type_id, msik.lot_status_enabled, msik.serial_status_enabled, p_organization_id, msik.inventory_item_id,
886: p_subinventory_code , p_locator_id , mln.lot_number, NULL, 'O') = 'Y'
887: UNION ALL
888: SELECT mln.lot_number LN
889: , mln.inventory_item_id