APPS.AHL_UTIL_PC_PKG dependencies on AHL_PC_NODES_B

Line 18: FROM ahl_pc_nodes_b

14: SELECT 'X'
15: FROM ahl_pc_associations
16: WHERE pc_node_id IN (
17: SELECT pc_node_id
18: FROM ahl_pc_nodes_b
19: START WITH pc_node_id = p_pc_node_id
20: CONNECT BY parent_node_id = PRIOR pc_node_id )
21: AND unit_item_id = p_inventory_id;
22:

Line 56: FROM ahl_pc_nodes_b

52: SELECT 'X'
53: FROM ahl_pc_associations
54: WHERE pc_node_id IN (
55: SELECT pc_node_id
56: FROM ahl_pc_nodes_b
57: CONNECT BY parent_node_id = PRIOR pc_node_id
58: START WITH pc_node_id = p_pc_node_id)
59: AND unit_item_id IN (
60: SELECT Unit_config_header_ID

Line 69: FROM ahl_pc_nodes_b

65: SELECT 'X'
66: FROM ahl_pc_associations
67: WHERE pc_node_id IN (
68: SELECT pc_node_id
69: FROM ahl_pc_nodes_b
70: CONNECT BY parent_node_id = PRIOR pc_node_id
71: START WITH pc_node_id = p_pc_node_id)
72: AND unit_item_id IN (
73: SELECT Unit_config_header_ID

Line 87: FROM ahl_pc_nodes_b

83: SELECT 'X'
84: FROM ahl_pc_associations
85: WHERE pc_node_id IN (
86: SELECT pc_node_id
87: FROM ahl_pc_nodes_b
88: CONNECT BY parent_node_id = PRIOR pc_node_id
89: START WITH pc_node_id = p_pc_node_id)
90: AND unit_item_id in (
91: SELECT inventory_item_id

Line 100: FROM ahl_pc_nodes_b

96: SELECT 'X'
97: FROM ahl_pc_associations
98: WHERE pc_node_id IN (
99: SELECT pc_node_id
100: FROM ahl_pc_nodes_b
101: CONNECT BY parent_node_id = PRIOR pc_node_id
102: START WITH pc_node_id = p_pc_node_id)
103: AND unit_item_id in (
104: SELECT inventory_item_id

Line 169: AHL_PC_NODES_B NODE

165: SELECT DISTINCT
166: AHASS.UNIT_ITEM_ID
167: FROM
168: AHL_PC_ASSOCIATIONS_V AHASS,
169: AHL_PC_NODES_B NODE
170: WHERE
171: AHASS.ASSOCIATION_TYPE_FLAG = 'I' AND
172: AHASS.PC_NODE_ID = NODE.PC_NODE_ID AND
173: NODE.PC_HEADER_ID = p_pc_header_id;

Line 198: AHL_PC_NODES_B NODE

194: SELECT DISTINCT
195: AHS.UNIT_ITEM_ID
196: FROM
197: AHL_PC_ASSOCIATIONS AHS,
198: AHL_PC_NODES_B NODE
199: WHERE
200: AHS.ASSOCIATION_TYPE_FLAG = 'I' AND
201: AHS.PC_NODE_ID = NODE.PC_NODE_ID AND
202: NODE.PC_HEADER_ID = p_pc_header_id;

Line 235: AHL_PC_NODES_B NODE

231: SELECT
232: AHASS.UNIT_ITEM_ID
233: FROM
234: AHL_PC_ASSOCIATIONS_V AHASS,
235: AHL_PC_NODES_B NODE
236: WHERE
237: AHASS.ASSOCIATION_TYPE_FLAG = 'U' AND
238: AHASS.PC_NODE_ID = NODE.PC_NODE_ID AND
239: NODE.PC_HEADER_ID = p_pc_header_id;

Line 268: AHL_PC_NODES_B NODE

264: SELECT
265: AHS.UNIT_ITEM_ID
266: FROM
267: AHL_PC_ASSOCIATIONS AHS,
268: AHL_PC_NODES_B NODE
269: WHERE
270: AHS.ASSOCIATION_TYPE_FLAG = 'U' AND
271: AHS.PC_NODE_ID = NODE.PC_NODE_ID AND
272: NODE.PC_HEADER_ID = p_pc_header_id;