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.AHL_PRD_MTLTXN_PVT dependencies on MTL_ITEM_LOCATIONS

Line 141: FROM MTL_ITEM_LOCATIONS_KFV

137:
138: -- Query for validating location segments and selecting location_id
139: /*CURSOR Location_Cur(p_org_id number, p_location_name varchar2) IS
140: SELECT INVENTORY_LOCATION_ID
141: FROM MTL_ITEM_LOCATIONS_KFV
142: WHERE ORGANIZATION_ID = p_org_Id
143: AND CONCATENATED_SEGMENTS = p_location_name
144: AND ((START_DATE_ACTIVE IS NULL) OR (START_DATE_ACTIVE <= SYSDATE))
145: AND ((END_DATE_ACTIVE IS NULL) OR (END_DATE_ACTIVE >= SYSDATE));*/

Line 151: FROM MTL_ITEM_LOCATIONS_KFV MIL_kfv, MTL_ITEM_LOCATIONS MIL

147: -- modified to retrieve segment19 and 20 from base table to fix bug# 6611033.
148: -- JKJain, removed Upper. Bug 9373744
149: CURSOR Location_Cur(p_org_id number, p_location_name varchar2) IS
150: SELECT MIL.INVENTORY_LOCATION_ID, MIL_kfv.CONCATENATED_SEGMENTS
151: FROM MTL_ITEM_LOCATIONS_KFV MIL_kfv, MTL_ITEM_LOCATIONS MIL
152: WHERE MIL_kfv.INVENTORY_LOCATION_ID = MIL.INVENTORY_LOCATION_ID
153: AND MIL.ORGANIZATION_ID = p_org_Id
154: AND decode(MIL.segment19, null, MIL_kfv.concatenated_segments,
155: INV_PROJECT.GET_LOCSEGS(MIL_kfv.concatenated_segments) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)

Line 2022: FROM AHL_WORKORDERS A, AHL_VISIT_TASKS_B B, AHL_VISITS_B C, MTL_ITEM_LOCATIONS LOC

2018: -- Added project and locator for ER# 5854712.
2019: CURSOR AHL_WIPJOB_CUR (p_org_id NUMBER, p_wo_id NUMBER, p_wipjob IN NUMBER) IS
2020: SELECT A.STATUS_CODE, C.Visit_id, C.Inv_Locator_Id, C.project_id, B.project_task_id,
2021: LOC.subinventory_code
2022: FROM AHL_WORKORDERS A, AHL_VISIT_TASKS_B B, AHL_VISITS_B C, MTL_ITEM_LOCATIONS LOC
2023: WHERE A.WIP_ENTITY_ID = p_wipjob
2024: AND A.WORKORDER_ID = p_wo_id
2025: AND B.VISIT_TASK_ID = A.VISIT_TASK_ID
2026: AND C.VISIT_ID = B.VISIT_ID

Line 2052: FROM MTL_ITEM_LOCATIONS

2048:
2049: -- Locator query
2050: CURSOR AHL_LOCATOR_CUR (p_org_id NUMBER, p_locator_id NUMBER, p_subinv VARCHAR2) IS
2051: SELECT 1
2052: FROM MTL_ITEM_LOCATIONS
2053: WHERE ORGANIZATION_ID = p_org_id
2054: AND INVENTORY_LOCATION_ID = p_locator_id
2055: ;--AND SUBINVENTORY_CODE = p_subinv;
2056:

Line 2227: l_subinventory_code mtl_item_locations.subinventory_code%TYPE;

2223: -- Added for ER# 5854712.
2224: l_inv_locator_id NUMBER;
2225: l_project_id NUMBER;
2226: l_project_task_id NUMBER;
2227: l_subinventory_code mtl_item_locations.subinventory_code%TYPE;
2228: l_project_locator_id NUMBER;
2229:
2230: -- added to fix 9268076 - match disposition attributes with txn attributes
2231: l_qa_collection_id NUMBER;

Line 5042: MTL_ITEM_LOCATIONS_KFV L

5038: BOM_DEPARTMENTS B,
5039: AHL_WORKORDER_OPERATIONS O,
5040: MTL_UNITS_OF_MEASURE_VL UOM,
5041: WIP_PARAMETERS WIP,
5042: MTL_ITEM_LOCATIONS_KFV L
5043: WHERE
5044: D.WORKORDER_ID = W.WORKORDER_ID AND
5045: W.MASTER_WORKORDER_FLAG = 'N' AND
5046: --W.STATUS_CODE NOT IN ('17', '22', '5','7','12') AND

Line 5151: concatenated_segments MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE,

5147: instance_id AHL_PRD_DISPOSITIONS_B.INSTANCE_ID%TYPE,
5148: instance_number CSI_ITEM_INSTANCES.instance_number%TYPE,
5149: default_pull_supply_subinv WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_SUBINV%TYPE,
5150: default_pull_supply_locator_id WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_LOCATOR_ID%TYPE,
5151: concatenated_segments MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE,
5152: quantity AHL_PRD_DISPOSITIONS_B.QUANTITY%TYPE,
5153: net_quantity CSI_ITEM_INSTANCES.QUANTITY%TYPE,
5154: Wo_Net_Total_Qty NUMBER,
5155: wip_entity_id AHL_WORKORDERS.WIP_ENTITY_ID%TYPE,

Line 5280: MTL_ITEM_LOCATIONS_KFV L,

5276: AHL_WORKORDER_OPERATIONS O,
5277: MTL_UNITS_OF_MEASURE_VL UOM,
5278: (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = ''AHL_JOB_STATUS'' AND LANGUAGE= USERENV(''LANG'')) WO_STS,
5279: WIP_PARAMETERS WP,
5280: MTL_ITEM_LOCATIONS_KFV L,
5281: AHL_WORKORDERS W ';
5282:
5283:
5284: l_mtl_txn_dtls_where := '

Line 6036: --MTL_ITEM_LOCATIONS_KFV MTL_LOC,

6032: AHL_WORKORDER_OPERATIONS WO_OP,
6033: MTL_SYSTEM_ITEMS_KFV MTL,
6034: MTL_UNITS_OF_MEASURE_VL UOM,
6035: -- modified to retrieve segment19 and 20 from base table to fix bug# 6611033.
6036: --MTL_ITEM_LOCATIONS_KFV MTL_LOC,
6037: MTL_ITEM_LOCATIONS MTL_LOC,
6038: WIP_PARAMETERS WP,
6039: PER_ALL_PEOPLE_F PER
6040: WHERE

Line 6037: MTL_ITEM_LOCATIONS MTL_LOC,

6033: MTL_SYSTEM_ITEMS_KFV MTL,
6034: MTL_UNITS_OF_MEASURE_VL UOM,
6035: -- modified to retrieve segment19 and 20 from base table to fix bug# 6611033.
6036: --MTL_ITEM_LOCATIONS_KFV MTL_LOC,
6037: MTL_ITEM_LOCATIONS MTL_LOC,
6038: WIP_PARAMETERS WP,
6039: PER_ALL_PEOPLE_F PER
6040: WHERE
6041: TXNS.TRANSACTION_TYPE_ID = 35 AND

Line 6115: --MTL_ITEM_LOCATIONS_KFV D,

6111: AHL_WORKORDER_MTL_TXNS A,
6112: MTL_SYSTEM_ITEMS_KFV B,
6113: MTL_UNITS_OF_MEASURE_VL UOM,
6114: -- modified to retrieve segment19 and 20 from base table to fix bug# 6611033.
6115: --MTL_ITEM_LOCATIONS_KFV D,
6116: MTL_ITEM_LOCATIONS D,
6117: AHL_WORKORDERS E,
6118: (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_JOB_STATUS' AND LANGUAGE= USERENV('LANG')) WO_STS,
6119: AHL_VISITS_B V,

Line 6116: MTL_ITEM_LOCATIONS D,

6112: MTL_SYSTEM_ITEMS_KFV B,
6113: MTL_UNITS_OF_MEASURE_VL UOM,
6114: -- modified to retrieve segment19 and 20 from base table to fix bug# 6611033.
6115: --MTL_ITEM_LOCATIONS_KFV D,
6116: MTL_ITEM_LOCATIONS D,
6117: AHL_WORKORDERS E,
6118: (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_JOB_STATUS' AND LANGUAGE= USERENV('LANG')) WO_STS,
6119: AHL_VISITS_B V,
6120: AHL_VISIT_TASKS_B VT,

Line 6597: MTL_ITEM_LOCATIONS D,

6593: MTL_SYSTEM_ITEMS_KFV I,
6594: AHL_SEARCH_WORKORDERS_v W,
6595: WIP_PARAMETERS P,
6596: MTL_UNITS_OF_MEASURE_VL UOM,
6597: MTL_ITEM_LOCATIONS D,
6598: MTL_PARAMETERS MP
6599: WHERE
6600: csi.inventory_item_id = I.inventory_item_id
6601: AND W.organization_id = MP.organization_id

Line 6759: MTL_ITEM_LOCATIONS D ';

6755: AHL_VISITS_B V,
6756: CSI_ITEM_INSTANCES C,
6757: MTL_UNITS_OF_MEASURE_VL UOM,
6758: WIP_PARAMETERS P,
6759: MTL_ITEM_LOCATIONS D ';
6760:
6761:
6762: l_mtl_txn_dtls_where := '
6763: WHERE V.VISIT_ID = W.VISIT_ID