APPS.AHL_MM_MTL_MGT_PVT dependencies on AHL_APPLICABLE_INSTANCES

Line 5510: --Get Net Reading for all UOM for all instances in AHL_APPLICABLE_INSTANCES table

5506: )
5507: IS
5508:
5509: --Local Cursors
5510: --Get Net Reading for all UOM for all instances in AHL_APPLICABLE_INSTANCES table
5511: CURSOR Get_Inst_Net_Reading
5512: IS
5513: SELECT CCA.SOURCE_OBJECT_ID ITEM_INSTANCE_ID,
5514: CC.COUNTER_ID,

Line 5524: AHL_APPLICABLE_INSTANCES APPL_INST

5520: WHERE CCR.COUNTER_VALUE_ID = CC.CTR_VAL_MAX_SEQ_NO
5521: AND NVL(CCR.DISABLED_FLAG,'N') = 'N'), 0) NET_READING
5522: FROM CSI_COUNTER_ASSOCIATIONS CCA,
5523: CSI_COUNTERS_VL CC,
5524: AHL_APPLICABLE_INSTANCES APPL_INST
5525: WHERE CCA.COUNTER_ID = CC.COUNTER_ID
5526: AND CCA.SOURCE_OBJECT_CODE = 'CP'
5527: AND CCA.SOURCE_OBJECT_ID = APPL_INST.CSI_ITEM_INSTANCE_ID;
5528:

Line 5650: ' INSERT INTO AHL_APPLICABLE_INSTANCES(CSI_ITEM_INSTANCE_ID, POSITION_ID)' ||

5646: l_debug CONSTANT VARCHAR2(90) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
5647:
5648: --for dynamic formation of query
5649: l_base_query VARCHAR2(8000) :=
5650: ' INSERT INTO AHL_APPLICABLE_INSTANCES(CSI_ITEM_INSTANCE_ID, POSITION_ID)' ||
5651: ' SELECT UNIQUE INST.instance_id, -1' ||
5652: ' FROM mtl_system_items_b ITEMS,' ||
5653: ' csi_item_instances INST,' ||
5654: ' mtl_serial_numbers SERIALS' ||

Line 5701: DELETE FROM ahl_applicable_instances;

5697: FND_LOG.string(l_log_statement, l_debug, 'Visit_Unit :' || p_demand_Record.Visit_Unit);
5698: END IF;
5699:
5700: --Clear the temp table before inserting new rows
5701: DELETE FROM ahl_applicable_instances;
5702:
5703: SELECT ASM.inventory_item_id,
5704: ASM.organization_id,
5705: ASM.mc_header_id,

Line 5746: --Call API to populate AHL_APPLICABLE_INSTANCES

5742: IF(NVL(p_demand_Record.Include_Alt_Items, 'N') <> 'Y') THEN
5743: l_inv_item_id_for_api := l_inventory_item_id;
5744: END IF;
5745:
5746: --Call API to populate AHL_APPLICABLE_INSTANCES
5747: --SB rules are applied by this API itself
5748: AHL_UC_INSTANCE_PVT.get_instances_for_req
5749: (p_api_version => 1.0,
5750: p_init_msg_list => FND_API.G_FALSE,

Line 6096: --Finally run the DDL statement to populate AHL_APPLICABLE_INSTANCES

6092: IF (l_log_statement >= l_log_current_level) THEN
6093: FND_LOG.string(l_log_statement, l_debug, 'Final Query: ' || l_base_query);
6094: END IF;
6095:
6096: --Finally run the DDL statement to populate AHL_APPLICABLE_INSTANCES
6097: EXECUTE IMMEDIATE l_base_query;
6098:
6099: END IF;
6100:

Line 6113: --Populate the instance table type from AHL_APPLICABLE_INSTANCES

6109:
6110: RETURN;
6111: END IF;
6112:
6113: --Populate the instance table type from AHL_APPLICABLE_INSTANCES
6114: OPEN Get_Inst_Net_Reading();
6115: LOOP
6116: FETCH Get_Inst_Net_Reading
6117: BULK COLLECT INTO l_appl_inst_tbl;

Line 6198: DELETE AHL_APPLICABLE_INSTANCES

6194: || ', net_reading:' || net_reading
6195: || ', build_goal_value:' || build_goal_value);
6196: END IF;
6197:
6198: DELETE AHL_APPLICABLE_INSTANCES
6199: WHERE CSI_ITEM_INSTANCE_ID = l_appl_inst_tbl(j).ITEM_INSTANCE_ID;
6200:
6201: IF (l_log_statement >= l_log_current_level) THEN
6202: FND_LOG.string(l_log_statement, l_debug,'After removing instance '