DBA Data[Home] [Help]

APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 121: FROM MTL_SYSTEM_ITEMS_KFV

117:
118: -- Query for validating item segments and selecting item id
119: CURSOR Item_Cur(p_org_id number, p_item_name varchar2) IS
120: SELECT Inventory_Item_Id
121: FROM MTL_SYSTEM_ITEMS_KFV
122: WHERE Concatenated_Segments = p_item_name
123: AND Organization_Id = p_org_id
124: AND ENABLED_FLAG = 'Y'
125: AND ((START_DATE_ACTIVE IS NULL) OR (START_DATE_ACTIVE <= SYSDATE))

Line 769: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;

765: l_object_version_number NUMBER;
766: l_uom_code AHL_SCHEDULE_MATERIALS.UOM%TYPE;
767: l_quantity NUMBER;
768:
769: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
770: l_workorder_name ahl_workorders.workorder_name%TYPE;
771:
772: l_reservation_flag VARCHAR2(1);
773: l_sr_mtl_id_map_tbl SR_MTL_ID_MAP_TBL;

Line 780: FROM MTL_TRANSACTIONS_INTERFACE INTF, mtl_system_items_kfv kfv,

776: CURSOR Txn_Error_Cur(p_txn_Id NUMBER) IS
777: SELECT intf.ERROR_EXPLANATION ,intf.ERROR_CODE, kfv.concatenated_segments,
778: WO.workorder_name
779: --FROM MTL_MATERIAL_TRANSACTIONS_TEMP
780: FROM MTL_TRANSACTIONS_INTERFACE INTF, mtl_system_items_kfv kfv,
781: ahl_workorders WO
782: --WHERE TRANSACTION_TEMP_ID = p_txn_Id;
783: WHERE TRANSACTION_INTERFACE_ID = p_txn_Id
784: AND intf.inventory_item_id = kfv.inventory_item_id

Line 1746: FROM MTL_SYSTEM_ITEMS_kfv

1742: -- Item id validation and selecting serial control code,lot control code values
1743: CURSOR AHL_ITEM_ID_CUR (p_org_id NUMBER, p_item NUMBER) IS
1744: SELECT SERIAL_NUMBER_CONTROL_CODE, LOT_CONTROL_CODE, REVISION_QTY_CONTROL_CODE,
1745: LOCATION_CONTROL_CODE,EAM_ITEM_TYPE, primary_uom_code, concatenated_segments
1746: FROM MTL_SYSTEM_ITEMS_kfv
1747: WHERE ORGANIZATION_ID = p_org_id
1748: AND INVENTORY_ITEM_ID = p_item
1749: AND ENABLED_FLAG = 'Y'
1750: AND ((START_DATE_ACTIVE IS NULL) OR (START_DATE_ACTIVE <= SYSDATE))

Line 1909: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;

1905: l_curr_subinventory_code mtl_serial_numbers.current_subinventory_code%TYPE;
1906: l_curr_locator_id NUMBER;
1907: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
1908: l_quantity NUMBER;
1909: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
1910: l_visit_id NUMBER;
1911: l_def_supply_subinv wip_parameters.default_pull_supply_subinv%TYPE;
1912: l_def_supply_locator_id NUMBER;
1913:

Line 3316: FROM MTL_SYSTEM_ITEMS_KFV

3312: AND C.VISIT_ID = B.VISIT_ID;
3313: --Query to select the item desccription
3314: CURSOR Item_Desc_Cur(p_org_id NUMBER, p_item_id NUMBER) IS
3315: SELECT DESCRIPTION
3316: FROM MTL_SYSTEM_ITEMS_KFV
3317: WHERE ORGANIZATION_ID = p_org_id
3318: AND INVENTORY_ITEM_ID = p_item_id;
3319:
3320: BEGIN

Line 4565: MTL_SYSTEM_ITEMS_KFV I,

4561: W.WIP_ENTITY_ID, -- added to filter chk_inst_relationship_csr for wip_job_id.
4562: (select inv_locator_id from ahl_visits_b where visit_id = w.visit_id) inv_locator_id
4563: FROM
4564: AHL_WORKORDER_MTL_TXNS T,
4565: MTL_SYSTEM_ITEMS_KFV I,
4566: AHL_WORKORDERS W,
4567: AHL_VISITS_B V,
4568: AHL_VISIT_TASKS_B VT,
4569: CS_INCIDENTS_ALL_B C,

Line 4678: MTL_SYSTEM_ITEMS_KFV MTL,

4674: (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_JOB_STATUS' AND LANGUAGE= USERENV('LANG')) WO_STS,
4675: AHL_VISIT_TASKS_B VST_TASK,
4676: AHL_VISITS_B VST,
4677: AHL_WORKORDER_OPERATIONS WO_OP,
4678: MTL_SYSTEM_ITEMS_KFV MTL,
4679: MTL_UNITS_OF_MEASURE_VL UOM,
4680: -- modified to retrieve segment19 and 20 from base table to fix bug# 6611033.
4681: --MTL_ITEM_LOCATIONS_KFV MTL_LOC,
4682: MTL_ITEM_LOCATIONS MTL_LOC,

Line 4753: MTL_SYSTEM_ITEMS_KFV B,

4749: --SYSDATE
4750: (select inv_locator_id from ahl_visits_b where visit_id = E.visit_id) inv_locator_id
4751: FROM
4752: AHL_WORKORDER_MTL_TXNS A,
4753: MTL_SYSTEM_ITEMS_KFV B,
4754: MTL_UNITS_OF_MEASURE_VL UOM,
4755: -- modified to retrieve segment19 and 20 from base table to fix bug# 6611033.
4756: --MTL_ITEM_LOCATIONS_KFV D,
4757: MTL_ITEM_LOCATIONS D,

Line 5082: MTL_SYSTEM_ITEMS_KFV I,

5078: DECODE(D.segment20,NULL,NULL,inv_project.GET_TASK_NUMBER(D.segment20)) Locator,
5079: (select inv_locator_id from ahl_visits_b where visit_id = w.visit_id) inv_locator_id
5080: FROM
5081: CSI_ITEM_INSTANCES CSI,
5082: MTL_SYSTEM_ITEMS_KFV I,
5083: AHL_SEARCH_WORKORDERS_v W,
5084: WIP_PARAMETERS P,
5085: MTL_UNITS_OF_MEASURE_VL UOM,
5086: MTL_ITEM_LOCATIONS D,