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_MM_MTL_MGT_PVT dependencies on AHL_SCHEDULE_MATERIALS

Line 150: FROM AHL_SCHEDULE_MATERIALS

146: REQUESTED_QUANTITY,
147: REQUESTED_DATE,
148: SCHEDULED_MATERIAL_ID,
149: NVL(COMPLETED_QUANTITY,0) COMPLETED_QUANTITY
150: FROM AHL_SCHEDULE_MATERIALS
151: WHERE SCHEDULED_MATERIAL_ID = P_SCHEDULE_MATERIAL_ID;
152:
153: CURSOR RESERVED_QTY_CSR(P_SCHEDULE_MATERIAL_ID NUMBER)
154: IS

Line 288: FROM AHL_SCHEDULE_MATERIALS

284: VISIT_TASK_ID,
285: SCHEDULED_MATERIAL_ID,
286: REQUESTED_QUANTITY,
287: NVL(COMPLETED_QUANTITY,0) COMPLETED_QUANTITY
288: FROM AHL_SCHEDULE_MATERIALS
289: WHERE SCHEDULED_MATERIAL_ID = P_SCHEDULE_MATERIAL_ID;
290:
291: P_X_MATERIAL_AVL_TBL AHL_LTP_MATRL_AVAL_PUB.PLANNED_MATRL_TBL;
292:

Line 450: FROM AHL_SCHEDULE_MATERIALS

446:
447: CURSOR SCHEDULE_MATERIAL_ID_CSR(L_VISIT_ID NUMBER)
448: IS
449: SELECT SCHEDULED_MATERIAL_ID
450: FROM AHL_SCHEDULE_MATERIALS
451: WHERE VISIT_ID = L_VISIT_ID;
452:
453: P_SCHEDULE_MATERIAL_ID_TBL NUMBER_TABLE_TYPE;
454: L_LOOP_COUNTER NUMBER;

Line 577: FROM ahl_schedule_materials ASM

573:
574: -- Query to fetch the requested quantity for the demand
575: SELECT requested_quantity
576: INTO l_req_qty
577: FROM ahl_schedule_materials ASM
578: WHERE ASM.scheduled_material_id = p_scheduled_material_id;
579:
580: -- Query to fetch total reserved quantity and max available date
581: SELECT MAX(ALL_RESERVATIONS.AVAILABLE_DATE) MAX_AVAILABLE_DATE,

Line 740: ahl_schedule_materials ASM,

736: l_dmd_subinv_code,
737: l_dmd_loc_id,
738: l_uom
739: FROM mtl_system_items_b ITEMS,
740: ahl_schedule_materials ASM,
741: ahl_visits_b VST,
742: mtl_item_locations LOC
743: WHERE ITEMS.inventory_item_id = ASM.inventory_item_id
744: AND ITEMS.organization_id = ASM.organization_id

Line 1185: FROM AHL_SCHEDULE_MATERIALS ASM,

1181: CURSOR get_demand_details(c_planning_window IN NUMBER) IS
1182: SELECT ASM.SCHEDULED_MATERIAL_ID,
1183: ASM.ATP_FLAG,
1184: WO.WORKORDER_NAME
1185: FROM AHL_SCHEDULE_MATERIALS ASM,
1186: AHL_WORKORDERS WO,
1187: AHL_VISIT_TASKS_B TSK
1188: WHERE (ASM.REQUESTED_QUANTITY - NVL(ASM.COMPLETED_QUANTITY,0) ) > 0
1189: AND ASM.STATUS = 'ACTIVE'

Line 1232: UPDATE ahl_schedule_materials

1228: RAISE FND_API.G_EXC_ERROR;
1229: END IF;
1230:
1231: --Revert ATP_FLAG for demands falling outside planning window due to change in required date
1232: UPDATE ahl_schedule_materials
1233: SET ATP_FLAG = 'N'
1234: WHERE status = 'ACTIVE'
1235: AND requested_date > sysdate + l_planning_window
1236: AND ATP_FLAG = 'Y';

Line 1250: UPDATE ahl_schedule_materials

1246: FND_FILE.put_line(FND_FILE.log,
1247: 'Updating ATP flag for ASM ID: ' || l_demand_rec.scheduled_material_id);
1248:
1249: --Update ATP flag of this demand row
1250: UPDATE ahl_schedule_materials
1251: SET ATP_FLAG = 'Y'
1252: WHERE scheduled_material_id = l_demand_rec.scheduled_material_id;
1253:
1254: END IF;

Line 1560: 'FROM ahl_schedule_materials asm, ahl_workorders wo ' ||

1556: --End of Get Workflow attributes.
1557:
1558: --Build asm id string from table of records recieved as parameter.
1559: l_sql_string := 'SELECT wo.workorder_name, asm.scheduled_material_id ' ||
1560: 'FROM ahl_schedule_materials asm, ahl_workorders wo ' ||
1561: 'WHERE ' ||
1562: 'asm.visit_task_id = wo.visit_task_id ' ||
1563: 'AND asm.scheduled_material_id IN ( 0';
1564: FOR i IN p_asm_id_tab.first..p_asm_id_tab.last

Line 1772: FROM AHL_SCHEDULE_MATERIALS ASM,

1768: SELECT MSI.SEGMENT1,
1769: MSI.INTERNAL_ORDER_ENABLED_FLAG
1770: INTO L_INVENTORY_ITEM,
1771: L_ISO_ENABLED_FLAG
1772: FROM AHL_SCHEDULE_MATERIALS ASM,
1773: MTL_SYSTEM_ITEMS_B MSI
1774: WHERE ASM.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
1775: AND ASM.ORGANIZATION_ID = MSI.ORGANIZATION_ID
1776: AND SCHEDULED_MATERIAL_ID = P_SCH_MTL_ID;

Line 2064: FROM AHL_SCHEDULE_MATERIALS

2060:
2061: -- step 1 - get inv item id
2062: SELECT inventory_item_id, ORGANIZATION_ID, REQUESTED_DATE
2063: INTO l_inventory_item_id, l_demand_org_id, l_need_by_date
2064: FROM AHL_SCHEDULE_MATERIALS
2065: where SCHEDULED_MATERIAL_ID = P_SCH_MTL_ID;
2066: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2067: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'l_inventory_item_id = ' || l_inventory_item_id);
2068: end if;

Line 2203: FROM AHL_VISITS_B AVB, MTL_ITEM_LOCATIONS_KFV MILK, AHL_SCHEDULE_MATERIALS ASM

2199: -- Get the demand sub inventory code and locator id value
2200: BEGIN
2201: SELECT MILK.SUBINVENTORY_CODE
2202: INTO L_DEMAND_SUBINV_CODE--, L_DEMAND_LOCATOR_ID
2203: FROM AHL_VISITS_B AVB, MTL_ITEM_LOCATIONS_KFV MILK, AHL_SCHEDULE_MATERIALS ASM
2204: WHERE AVB.INV_LOCATOR_ID = MILK.INVENTORY_LOCATION_ID(+)
2205: AND ASM.VISIT_ID = AVB.VISIT_ID
2206: and ASM.SCHEDULED_MATERIAL_ID = P_SCH_MTL_ID;
2207: EXCEPTION

Line 2698: L_RSV_REC.DEMAND_SOURCE_LINE_DETAIL := P_SCHEDULED_MATERIAL_ID; --

2694: l_api_name CONSTANT VARCHAR2(80) := 'AHL_MM_MTL_MGT_PVT.CREATE_RESERVATION_IR';
2695:
2696: BEGIN
2697:
2698: L_RSV_REC.DEMAND_SOURCE_LINE_DETAIL := P_SCHEDULED_MATERIAL_ID; --
2699: l_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_internal_req;
2700: l_rsv_rec.supply_source_header_id := p_internal_req_hdr_id;
2701: L_RSV_REC.SUPPLY_SOURCE_LINE_ID := P_INTERNAL_REQ_LINE_ID;
2702: L_RSV_REC.SUPPLY_SOURCE_LINE_DETAIL := NULL;

Line 3749: AHL_SCHEDULE_MATERIALS ASM WHERE AWO.VISIT_TASK_ID = ASM.VISIT_TASK_ID

3745: IS
3746:
3747: L_CUR AHL_OSP_UTIL_PKG.AHL_SEARCH_CSR;
3748: L_SQL_STRING VARCHAR2(30000) := 'SELECT distinct AWO.WORKORDER_ID,AWO.OBJECT_VERSION_NUMBER FROM AHL_WORKORDERS AWO,
3749: AHL_SCHEDULE_MATERIALS ASM WHERE AWO.VISIT_TASK_ID = ASM.VISIT_TASK_ID
3750: AND AWO.VISIT_TASK_ID = ASM.VISIT_TASK_ID AND ASM.SCHEDULED_MATERIAL_ID in(';
3751: L_BINDVAR_TBL AHL_OSP_UTIL_PKG.AHL_CONDITIONS_TBL;
3752: P_WORK_ORDER_ID_TBL AHL_PRD_WORKORDER_PVT.WORKORDER_ID_TBL_TYPE;
3753: L_WORKORDER_ID NUMBER;

Line 3884: SELECT AOG_FLAG FROM AHL_SCHEDULE_MATERIALS WHERE SCHEDULED_MATERIAL_ID = P_SCHEDULE_MATERIAL_ID;

3880: )
3881: IS
3882:
3883: CURSOR CURRENT_AOG_CSR(P_SCHEDULE_MATERIAL_ID NUMBER) IS
3884: SELECT AOG_FLAG FROM AHL_SCHEDULE_MATERIALS WHERE SCHEDULED_MATERIAL_ID = P_SCHEDULE_MATERIAL_ID;
3885:
3886: P_SCHEDULE_MATERIAL_ID_TBL NUMBER_TABLE_TYPE;
3887: P_COUNT NUMBER := 1;
3888:

Line 3920: UPDATE AHL_SCHEDULE_MATERIALS SET

3916: P_SCHEDULE_MATERIAL_ID_TBL(P_COUNT) := P_AOG_TBL(I).SCHEDULE_MATERIAL_ID;
3917: P_COUNT := P_COUNT + 1;
3918: END IF;
3919: IF(NOT((P_AOG_TBL(I).AOG_FLAG = 'N' OR P_AOG_TBL(I).AOG_FLAG = 'n') AND CURRENT_AOG.AOG_FLAG IS NULL ))THEN
3920: UPDATE AHL_SCHEDULE_MATERIALS SET
3921: AOG_FLAG = P_AOG_TBL(I).AOG_FLAG,
3922: OBJECT_VERSION_NUMBER = P_AOG_TBL(I).ASM_OBJECT_VERSION_NUMBER + 1,
3923: LAST_UPDATE_DATE = SYSDATE,
3924: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 5544: FROM AHL_SCHEDULE_MATERIALS ASM,

5540: ELSE (INTV.INTERVAL_VALUE - BG.COUNTER_VALUE) -- Mandatory or Optional Implement
5541: END MAX_COUNTER_VALUE,
5542: MR.TITLE MR_TITLE,
5543: MR.MR_HEADER_ID MR_HEADER_ID
5544: FROM AHL_SCHEDULE_MATERIALS ASM,
5545: AHL_MR_INTERVALS INTV,
5546: CS_COUNTERS CNTR,
5547: MTL_UNITS_OF_MEASURE_VL UOM,
5548: AHL_BUILD_GOALS BG,

Line 5713: FROM ahl_schedule_materials ASM,

5709: l_org_id,
5710: l_mc_header_id,
5711: l_pos_key,
5712: l_uc_header_id
5713: FROM ahl_schedule_materials ASM,
5714: ahl_visits_b VST,
5715: ahl_visit_tasks_b TSK
5716: WHERE ASM.visit_id = VST.visit_id
5717: AND ASM.visit_task_id = TSK.visit_task_id

Line 5870: FROM AHL_SCHEDULE_MATERIALS

5866:
5867: --Instance Validation
5868: SELECT relationship_id
5869: INTO l_relationship_id
5870: FROM AHL_SCHEDULE_MATERIALS
5871: WHERE scheduled_material_id = p_demand_Record.Scheduled_Material_ID;
5872:
5873: --Check if instance is valid for the position with a function
5874: l_base_query := l_base_query

Line 6440: FROM AHL_SCHEDULE_MATERIALS

6436:
6437: CURSOR SCHEDULE_MATERIAL_ID_CSR(L_VISIT_ID NUMBER)
6438: IS
6439: SELECT SCHEDULED_MATERIAL_ID
6440: FROM AHL_SCHEDULE_MATERIALS
6441: WHERE VISIT_ID = L_VISIT_ID;
6442:
6443: P_SCHEDULE_MATERIAL_ID_TBL NUMBER_TABLE_TYPE;
6444: L_LOOP_COUNTER NUMBER;