APPS.AHL_UC_TREE_PVT dependencies on AHL_ITEM_ASSOCIATIONS_B

Line 1169: ahl_item_associations_b I

1165: SELECT M.relationship_id,
1166: I.inventory_item_id,
1167: I.inventory_org_id
1168: FROM ahl_mc_relationships M,
1169: ahl_item_associations_b I
1170: WHERE M.mc_header_id = c_mc_header_id
1171: AND M.parent_relationship_id IS NULL
1172: AND M.item_group_id = I.item_group_id;
1173: /*

Line 1177: FROM ahl_item_associations_b

1173: /*
1174: CURSOR get_associated_items(c_item_group_id NUMBER) IS
1175: SELECT inventory_item_id,
1176: inventory_org_id
1177: FROM ahl_item_associations_b
1178: WHERE item_group_id = c_item_group_id;
1179: l_get_associated_item get_associated_items%ROWTYPE;
1180: */
1181:

Line 1916: ahl_item_associations_b I

1912: SELECT M.relationship_id,
1913: I.inventory_item_id,
1914: I.inventory_org_id
1915: FROM ahl_mc_relationships M,
1916: ahl_item_associations_b I
1917: WHERE M.relationship_id = p_relationship_id
1918: AND M.item_group_id = I.item_group_id
1919: AND trunc(nvl(M.active_start_date,SYSDATE)) <= trunc(SYSDATE)
1920: AND trunc(nvl(M.active_end_date, SYSDATE+1)) > trunc(SYSDATE);

Line 1927: FROM ahl_item_associations_b

1923: /*
1924: CURSOR get_associated_items(c_item_group_id NUMBER) IS
1925: SELECT inventory_item_id,
1926: inventory_org_id
1927: FROM ahl_item_associations_b
1928: WHERE item_group_id = c_item_group_id;
1929: l_get_associated_item get_associated_items%ROWTYPE;
1930: */
1931: --Given an instance_id, get all of its immediate children from csi_ii_relationships