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_BLK_PARTS_CHANGE_PVT dependencies on AHL_MC_RELATIONSHIPS

Line 561: FROM AHL_MC_RELATIONSHIPS MCR, FND_LOOKUP_VALUES_VL ATA

557:
558: -- Cursor to get MC details for the given MC relationship id
559: CURSOR get_mc_details_csr (c_relationship_id NUMBER) IS
560: SELECT ATA.meaning ata_meaning
561: FROM AHL_MC_RELATIONSHIPS MCR, FND_LOOKUP_VALUES_VL ATA
562: WHERE MCR.relationship_id = c_relationship_id
563: AND ATA.lookup_code (+) = MCR.ata_code
564: AND ATA.lookup_type (+) = 'AHL_ATA_CODE';
565:

Line 1411: FROM AHL_MC_RELATIONSHIPS reln,

1407: csi.inventory_item_id,
1408: csi.quantity Inst_qty,
1409: csi.unit_of_measure Inst_uom_code
1410:
1411: FROM AHL_MC_RELATIONSHIPS reln,
1412: AHL_ITEM_ASSOCIATIONS_B iasso,
1413: CSI_ITEM_INSTANCES csi
1414:
1415: WHERE reln.relationship_id = p_mc_relationship_id

Line 1429: FROM AHL_MC_RELATIONSHIPS

1425: uom_code Posn_uom_code,
1426: to_number(null) Inventory_item_id,
1427: to_number(null) Inst_qty,
1428: to_char(null) Inst_uom_code
1429: FROM AHL_MC_RELATIONSHIPS
1430: WHERE p_instance_id IS NULL
1431: AND relationship_id = p_mc_relationship_id;
1432:
1433: -- Cursor to get UOM meaning given UOM code

Line 1561: FROM AHL_MC_RELATIONSHIPS RELN,

1557:
1558: -- Cursor to get unit of measure for the given Control position
1559: CURSOR get_uom_for_cntrl_pos_csr (c_relationship_id NUMBER) IS
1560: SELECT unit_of_measure
1561: FROM AHL_MC_RELATIONSHIPS RELN,
1562: MTL_UNITS_OF_MEASURE_VL UOM
1563: WHERE RELN.relationship_id = c_relationship_id
1564: AND UOM.uom_code = RELN.uom_code;
1565: