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 644: FROM ahl_pc_associations ahass

640: START WITH pc_node_id = l_node_id;
641:
642: SELECT pc_association_id
643: BULK COLLECT INTO l_assos_tbl
644: FROM ahl_pc_associations ahass
645: WHERE pc_node_id IN (
646: SELECT pc_node_id
647: FROM ahl_pc_nodes_b
648: WHERE pc_header_id = l_link_to_header_id

Line 673: UPDATE AHL_PC_ASSOCIATIONS

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

Line 838: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,

834: AHS.ATTRIBUTE12,
835: AHS.ATTRIBUTE13,
836: AHS.ATTRIBUTE14,
837: AHS.ATTRIBUTE15
838: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
839: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
840: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
841: WHERE p_copy_assos_flag = 'Y'
842: AND NODE.PC_HEADER_ID = HEADER.PC_HEADER_ID

Line 1456: FROM AHL_PC_ASSOCIATIONS AHS,

1452: WHERE PC_HEADER_ID = p_header_id AND
1453: NODE_TYPE IN (G_PART, G_UNIT);
1454: */
1455: SELECT 'X'
1456: FROM AHL_PC_ASSOCIATIONS AHS,
1457: AHL_PC_NODES_B NODE
1458: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
1459: AND NODE.PC_HEADER_ID = p_header_id;
1460:

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

1511:
1512: CURSOR get_dup_assos (p_pc_header_id IN NUMBER)
1513: IS
1514: select ahass.unit_item_id, count(ahass.pc_node_id)
1515: from ahl_pc_headers_b head, ahl_pc_nodes_b node, ahl_pc_associations ahass
1516: where ahass.pc_node_id = node.pc_node_id and
1517: node.pc_header_id = head.pc_header_id and
1518: head.pc_header_id = p_pc_header_id
1519: group by ahass.unit_item_id

Line 1582: DELETE FROM AHL_PC_ASSOCIATIONS

1578: WHERE ASO_OBJECT_TYPE_CODE = 'PC' and
1579: ASO_OBJECT_ID = l_node_tbl(i);
1580:
1581: -- Knocking off the Units / Parts
1582: DELETE FROM AHL_PC_ASSOCIATIONS
1583: WHERE PC_NODE_ID = l_node_tbl(i);
1584:
1585: -- Knocking off the node
1586: AHL_PC_NODES_PKG.DELETE_ROW(l_node_tbl(i));

Line 1708: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,

1704: AHS.ATTRIBUTE12,
1705: AHS.ATTRIBUTE13,
1706: AHS.ATTRIBUTE14,
1707: AHS.ATTRIBUTE15
1708: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
1709: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
1710: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
1711: WHERE NODE.PC_HEADER_ID = HEADER.PC_HEADER_ID
1712: AND NODE.PC_NODE_ID = AHS.PC_NODE_ID

Line 1873: UPDATE AHL_PC_ASSOCIATIONS

1869: l_assos_rec.ATTRIBUTE13 := l_node_data_rec.ATTRIBUTE13;
1870: l_assos_rec.ATTRIBUTE14 := l_node_data_rec.ATTRIBUTE14;
1871: l_assos_rec.ATTRIBUTE15 := l_node_data_rec.ATTRIBUTE15;
1872:
1873: UPDATE AHL_PC_ASSOCIATIONS
1874: SET DRAFT_FLAG = 'Y'
1875: WHERE PC_ASSOCIATION_ID = l_node_data_rec.PC_NODE_ID;
1876:
1877: END IF;

Line 2132: FROM ahl_pc_associations ahass

2128: END IF;
2129:
2130: SELECT pc_association_id
2131: BULK COLLECT INTO l_assos_tbl
2132: FROM ahl_pc_associations ahass
2133: WHERE pc_node_id IN (
2134: SELECT pc_node_id
2135: FROM ahl_pc_nodes_b
2136: WHERE pc_header_id = p_x_node_rec.pc_header_id

Line 2155: FROM ahl_pc_associations

2151: END IF;
2152:
2153: -- Knocking off unit/part associations...
2154: DELETE
2155: FROM ahl_pc_associations
2156: WHERE pc_association_id = l_assos_tbl(i);
2157: END LOOP;
2158: END IF;
2159:

Line 2213: DELETE FROM AHL_PC_ASSOCIATIONS

2209:
2210:
2211: BEGIN
2212: -- Knocking off units...
2213: DELETE FROM AHL_PC_ASSOCIATIONS
2214: WHERE PC_ASSOCIATION_ID = p_x_assos_rec.PC_ASSOCIATION_ID;
2215:
2216: IF G_DEBUG='Y' THEN
2217: AHL_DEBUG_PUB.debug('PCH -- PVT -- DETACH_UNIT_REMOVE_LINK for ID='||p_x_assos_rec.PC_ASSOCIATION_ID);

Line 2234: DELETE FROM AHL_PC_ASSOCIATIONS

2230: IS
2231:
2232: BEGIN
2233: -- Knocking off items...
2234: DELETE FROM AHL_PC_ASSOCIATIONS
2235: WHERE PC_ASSOCIATION_ID = p_x_assos_rec.PC_ASSOCIATION_ID;
2236:
2237: IF G_DEBUG='Y' THEN
2238: AHL_DEBUG_PUB.debug('PCH -- PVT -- DETACH_ITEM_REMOVE_LINK for ID='||p_x_assos_rec.PC_ASSOCIATION_ID);

Line 2345: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,

2341: AHS.ATTRIBUTE12,
2342: AHS.ATTRIBUTE13,
2343: AHS.ATTRIBUTE14,
2344: AHS.ATTRIBUTE15
2345: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
2346: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
2347: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
2348: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
2349: AND HEADER.PC_HEADER_ID = NODE.PC_HEADER_ID

Line 2438: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,

2434: MTL.DESCRIPTION,
2435: AHS.ASSOCIATION_TYPE_FLAG NODE_TYPE,
2436: AHS.UNIT_ITEM_ID,
2437: AHS.INVENTORY_ORG_ID
2438: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
2439: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
2440: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
2441: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
2442: AND HEADER.PC_HEADER_ID = NODE.PC_HEADER_ID

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

2458: -- NODE ID NOT FOUND IN LINKED PC - i.e. NODE HAS BEEN DELETED
2459: NOT EXISTS
2460: (
2461: -- Changes by skpathak on 27-NOV-2008 for bug 7512088
2462: -- If the table AHL_PC_ASSOCIATIONS does not have any records,
2463: -- the following this sub query does not bring any rows even
2464: -- if all other conditions are met. Hence changing this into a union
2465: -- of two queries
2466: /*

Line 2468: FROM AHL_PC_ASSOCIATIONS ASSOC,AHL_PC_NODES_B NODE

2464: -- if all other conditions are met. Hence changing this into a union
2465: -- of two queries
2466: /*
2467: SELECT 'X'
2468: FROM AHL_PC_ASSOCIATIONS ASSOC,AHL_PC_NODES_B NODE
2469: WHERE NODE.PC_HEADER_ID = p_header_id
2470: AND (
2471: (TREE.NODE_TYPE = 'N' AND
2472: TREE.PC_NODE_ID = NODE.LINK_TO_NODE_ID)

Line 2486: FROM AHL_PC_NODES_B NODE, AHL_PC_ASSOCIATIONS ASSOC

2482: AND TREE.NODE_TYPE = 'N'
2483: AND TREE.PC_NODE_ID = NODE.LINK_TO_NODE_ID
2484: UNION ALL
2485: SELECT 'X'
2486: FROM AHL_PC_NODES_B NODE, AHL_PC_ASSOCIATIONS ASSOC
2487: WHERE NODE.PC_HEADER_ID = p_header_id
2488: AND TREE.NODE_TYPE IN ('I', 'U')
2489: AND ASSOC.PC_NODE_ID = NODE.PC_NODE_ID
2490: AND TREE.PC_NODE_ID = ASSOC.LINK_TO_ASSOCIATION_ID

Line 2510: SELECT * FROM ahl_pc_associations

2506: ORDER BY TREE.PARENT_NODE_ID;
2507:
2508: CURSOR detach_associations(p_header_id in number, p_link_header_id in number)
2509: IS
2510: SELECT * FROM ahl_pc_associations
2511: WHERE pc_node_id in ( SELECT PC_NODE_ID
2512: FROM ahl_pc_nodes_b
2513: WHERE PC_HEADER_ID = p_link_header_id)
2514: AND pc_association_id NOT IN (

Line 2516: FROM ahl_pc_associations

2512: FROM ahl_pc_nodes_b
2513: WHERE PC_HEADER_ID = p_link_header_id)
2514: AND pc_association_id NOT IN (
2515: SELECT LINK_TO_ASSOCIATION_ID
2516: FROM ahl_pc_associations
2517: WHERE pc_node_id IN ( SELECT PC_NODE_ID
2518: FROM ahl_pc_nodes_b
2519: WHERE PC_HEADER_ID = p_header_id));
2520:

Line 2951: FROM AHL_PC_ASSOCIATIONS

2947: l_assos_rec.ATTRIBUTE14 := l_node_data_rec.ATTRIBUTE14;
2948: l_assos_rec.ATTRIBUTE15 := l_node_data_rec.ATTRIBUTE15;
2949:
2950: SELECT OBJECT_VERSION_NUMBER INTO l_assos_rec.OBJECT_VERSION_NUMBER
2951: FROM AHL_PC_ASSOCIATIONS
2952: WHERE PC_ASSOCIATION_ID = l_assos_rec.PC_ASSOCIATION_ID;
2953:
2954: END IF;
2955:

Line 3321: FROM AHL_PC_ASSOCIATIONS AHS,

3317: WHERE PC_HEADER_ID = p_pc_header_id AND
3318: NODE_TYPE IN (G_PART, G_UNIT);
3319: */
3320: SELECT 'X'
3321: FROM AHL_PC_ASSOCIATIONS AHS,
3322: AHL_PC_NODES_B NODE
3323: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
3324: AND NODE.PC_HEADER_ID = p_pc_header_id;
3325:

Line 3397: FROM AHL_PC_ASSOCIATIONS AHS,

3393: WHERE PC_HEADER_ID = p_header_id AND
3394: NODE_TYPE IN (G_PART, G_UNIT);
3395: */
3396: SELECT 'X'
3397: FROM AHL_PC_ASSOCIATIONS AHS,
3398: AHL_PC_NODES_B NODE
3399: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
3400: AND NODE.PC_HEADER_ID = p_header_id;
3401: