APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_ITEM_LOCATIONS_KFV

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 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 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,