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_PC_HEADER_PVT dependencies on AHL_PC_ASSOCIATIONS

Line 648: FROM ahl_pc_associations ahass

644: START WITH pc_node_id = l_node_id;
645:
646: SELECT pc_association_id
647: BULK COLLECT INTO l_assos_tbl
648: FROM ahl_pc_associations ahass
649: WHERE pc_node_id IN (
650: SELECT pc_node_id
651: FROM ahl_pc_nodes_b
652: WHERE pc_header_id = l_link_to_header_id

Line 677: UPDATE AHL_PC_ASSOCIATIONS

673: LOOP
674: IF G_DEBUG='Y' THEN
675: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_HEADER -- Done for Association ID='||l_assos_tbl(j));
676: END IF;
677: UPDATE AHL_PC_ASSOCIATIONS
678: SET DRAFT_FLAG = 'N'
679: WHERE PC_ASSOCIATION_ID = l_assos_tbl(j);
680: END LOOP;
681: END IF;

Line 849: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,

845: AHS.ATTRIBUTE12,
846: AHS.ATTRIBUTE13,
847: AHS.ATTRIBUTE14,
848: AHS.ATTRIBUTE15
849: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
850: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
851: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
852: WHERE p_copy_assos_flag = 'Y'
853: AND NODE.PC_HEADER_ID = HEADER.PC_HEADER_ID

Line 1534: FROM AHL_PC_ASSOCIATIONS AHS,

1530: WHERE PC_HEADER_ID = p_header_id AND
1531: NODE_TYPE IN (G_PART, G_UNIT);
1532: */
1533: SELECT 'X'
1534: FROM AHL_PC_ASSOCIATIONS AHS,
1535: AHL_PC_NODES_B NODE
1536: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
1537: AND NODE.PC_HEADER_ID = p_header_id;
1538:

Line 1593: from ahl_pc_headers_b head, ahl_pc_nodes_b node, ahl_pc_associations ahass

1589:
1590: CURSOR get_dup_assos (p_pc_header_id IN NUMBER)
1591: IS
1592: select ahass.unit_item_id, count(ahass.pc_node_id)
1593: from ahl_pc_headers_b head, ahl_pc_nodes_b node, ahl_pc_associations ahass
1594: where ahass.pc_node_id = node.pc_node_id and
1595: node.pc_header_id = head.pc_header_id and
1596: head.pc_header_id = p_pc_header_id
1597: group by ahass.unit_item_id

Line 1660: DELETE FROM AHL_PC_ASSOCIATIONS

1656: WHERE ASO_OBJECT_TYPE_CODE = 'PC' and
1657: ASO_OBJECT_ID = l_node_tbl(i);
1658:
1659: -- Knocking off the Units / Parts
1660: DELETE FROM AHL_PC_ASSOCIATIONS
1661: WHERE PC_NODE_ID = l_node_tbl(i);
1662:
1663: -- Knocking off the node
1664: AHL_PC_NODES_PKG.DELETE_ROW(l_node_tbl(i));

Line 1792: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,

1788: AHS.ATTRIBUTE12,
1789: AHS.ATTRIBUTE13,
1790: AHS.ATTRIBUTE14,
1791: AHS.ATTRIBUTE15
1792: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
1793: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
1794: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
1795: WHERE NODE.PC_HEADER_ID = HEADER.PC_HEADER_ID
1796: AND NODE.PC_NODE_ID = AHS.PC_NODE_ID

Line 2093: UPDATE AHL_PC_ASSOCIATIONS

2089: l_assos_rec.ATTRIBUTE13 := l_node_asso_rec.ATTRIBUTE13;
2090: l_assos_rec.ATTRIBUTE14 := l_node_asso_rec.ATTRIBUTE14;
2091: l_assos_rec.ATTRIBUTE15 := l_node_asso_rec.ATTRIBUTE15;
2092:
2093: UPDATE AHL_PC_ASSOCIATIONS
2094: SET DRAFT_FLAG = 'Y'
2095: WHERE PC_ASSOCIATION_ID = l_node_asso_rec.PC_NODE_ID;
2096:
2097: END IF;

Line 2286: FROM ahl_pc_associations ahass

2282: END IF;
2283:
2284: SELECT pc_association_id
2285: BULK COLLECT INTO l_assos_tbl
2286: FROM ahl_pc_associations ahass
2287: WHERE pc_node_id IN (
2288: SELECT pc_node_id
2289: FROM ahl_pc_nodes_b
2290: WHERE pc_header_id = p_x_node_rec.pc_header_id

Line 2309: FROM ahl_pc_associations

2305: END IF;
2306:
2307: -- Knocking off unit/part associations...
2308: DELETE
2309: FROM ahl_pc_associations
2310: WHERE pc_association_id = l_assos_tbl(i);
2311: END LOOP;
2312: END IF;
2313:

Line 2367: DELETE FROM AHL_PC_ASSOCIATIONS

2363:
2364:
2365: BEGIN
2366: -- Knocking off units...
2367: DELETE FROM AHL_PC_ASSOCIATIONS
2368: WHERE PC_ASSOCIATION_ID = p_x_assos_rec.PC_ASSOCIATION_ID;
2369:
2370: IF G_DEBUG='Y' THEN
2371: AHL_DEBUG_PUB.debug('PCH -- PVT -- DETACH_UNIT_REMOVE_LINK for ID='||p_x_assos_rec.PC_ASSOCIATION_ID);

Line 2388: DELETE FROM AHL_PC_ASSOCIATIONS

2384: IS
2385:
2386: BEGIN
2387: -- Knocking off items...
2388: DELETE FROM AHL_PC_ASSOCIATIONS
2389: WHERE PC_ASSOCIATION_ID = p_x_assos_rec.PC_ASSOCIATION_ID;
2390:
2391: IF G_DEBUG='Y' THEN
2392: AHL_DEBUG_PUB.debug('PCH -- PVT -- DETACH_ITEM_REMOVE_LINK for ID='||p_x_assos_rec.PC_ASSOCIATION_ID);

Line 2505: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,

2501: AHS.ATTRIBUTE12,
2502: AHS.ATTRIBUTE13,
2503: AHS.ATTRIBUTE14,
2504: AHS.ATTRIBUTE15
2505: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
2506: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
2507: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
2508: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
2509: AND HEADER.PC_HEADER_ID = NODE.PC_HEADER_ID

Line 2594: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,

2590: MTL.DESCRIPTION,
2591: AHS.ASSOCIATION_TYPE_FLAG NODE_TYPE,
2592: AHS.UNIT_ITEM_ID,
2593: AHS.INVENTORY_ORG_ID
2594: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
2595: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
2596: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
2597: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
2598: AND HEADER.PC_HEADER_ID = NODE.PC_HEADER_ID

Line 2618: -- If the table AHL_PC_ASSOCIATIONS does not have any records,

2614: -- NODE ID NOT FOUND IN LINKED PC - i.e. NODE HAS BEEN DELETED
2615: NOT EXISTS
2616: (
2617: -- Changes by skpathak on 27-NOV-2008 for bug 7512088
2618: -- If the table AHL_PC_ASSOCIATIONS does not have any records,
2619: -- the following this sub query does not bring any rows even
2620: -- if all other conditions are met. Hence changing this into a union
2621: -- of two queries
2622: /*

Line 2624: FROM AHL_PC_ASSOCIATIONS ASSOC,AHL_PC_NODES_B NODE

2620: -- if all other conditions are met. Hence changing this into a union
2621: -- of two queries
2622: /*
2623: SELECT 'X'
2624: FROM AHL_PC_ASSOCIATIONS ASSOC,AHL_PC_NODES_B NODE
2625: WHERE NODE.PC_HEADER_ID = p_header_id
2626: AND (
2627: (TREE.NODE_TYPE = 'N' AND
2628: TREE.PC_NODE_ID = NODE.LINK_TO_NODE_ID)

Line 2642: FROM AHL_PC_NODES_B NODE, AHL_PC_ASSOCIATIONS ASSOC

2638: AND TREE.NODE_TYPE = 'N'
2639: AND TREE.PC_NODE_ID = NODE.LINK_TO_NODE_ID
2640: UNION ALL
2641: SELECT 'X'
2642: FROM AHL_PC_NODES_B NODE, AHL_PC_ASSOCIATIONS ASSOC
2643: WHERE NODE.PC_HEADER_ID = p_header_id
2644: AND TREE.NODE_TYPE IN ('I', 'U')
2645: AND ASSOC.PC_NODE_ID = NODE.PC_NODE_ID
2646: AND TREE.PC_NODE_ID = ASSOC.LINK_TO_ASSOCIATION_ID

Line 2666: SELECT * FROM ahl_pc_associations

2662: ORDER BY TREE.PARENT_NODE_ID;
2663:
2664: CURSOR detach_associations(p_header_id in number, p_link_header_id in number)
2665: IS
2666: SELECT * FROM ahl_pc_associations
2667: WHERE pc_node_id in ( SELECT PC_NODE_ID
2668: FROM ahl_pc_nodes_b
2669: WHERE PC_HEADER_ID = p_link_header_id)
2670: AND pc_association_id NOT IN (

Line 2672: FROM ahl_pc_associations

2668: FROM ahl_pc_nodes_b
2669: WHERE PC_HEADER_ID = p_link_header_id)
2670: AND pc_association_id NOT IN (
2671: SELECT LINK_TO_ASSOCIATION_ID
2672: FROM ahl_pc_associations
2673: WHERE pc_node_id IN ( SELECT PC_NODE_ID
2674: FROM ahl_pc_nodes_b
2675: WHERE PC_HEADER_ID = p_header_id));
2676:

Line 3188: FROM AHL_PC_ASSOCIATIONS

3184: l_assos_rec.ATTRIBUTE14 := l_node_units_data_rec.ATTRIBUTE14;
3185: l_assos_rec.ATTRIBUTE15 := l_node_units_data_rec.ATTRIBUTE15;
3186:
3187: SELECT OBJECT_VERSION_NUMBER INTO l_assos_rec.OBJECT_VERSION_NUMBER
3188: FROM AHL_PC_ASSOCIATIONS
3189: WHERE PC_ASSOCIATION_ID = l_assos_rec.PC_ASSOCIATION_ID;
3190: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3191: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',
3192: 'Got l_node_rec.OBJECT_VERSION_NUMBER as ' || l_node_rec.OBJECT_VERSION_NUMBER);

Line 3554: FROM AHL_PC_ASSOCIATIONS AHS,

3550: WHERE PC_HEADER_ID = p_pc_header_id AND
3551: NODE_TYPE IN (G_PART, G_UNIT);
3552: */
3553: SELECT 'X'
3554: FROM AHL_PC_ASSOCIATIONS AHS,
3555: AHL_PC_NODES_B NODE
3556: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
3557: AND NODE.PC_HEADER_ID = p_pc_header_id;
3558:

Line 3631: FROM AHL_PC_ASSOCIATIONS AHS,

3627: WHERE PC_HEADER_ID = p_header_id AND
3628: NODE_TYPE IN (G_PART, G_UNIT);
3629: */
3630: SELECT 'X'
3631: FROM AHL_PC_ASSOCIATIONS AHS,
3632: AHL_PC_NODES_B NODE
3633: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
3634: AND NODE.PC_HEADER_ID = p_header_id;
3635: