APPS.AHL_UC_TREE_PVT dependencies on AHL_ITEM_ASSOCIATIONS_B

Line 1211: ahl_item_associations_b I

1207: SELECT M.relationship_id,
1208: I.inventory_item_id,
1209: I.inventory_org_id
1210: FROM ahl_mc_relationships M,
1211: ahl_item_associations_b I
1212: WHERE M.mc_header_id = c_mc_header_id
1213: AND M.parent_relationship_id IS NULL
1214: AND M.item_group_id = I.item_group_id;
1215: /*

Line 1219: FROM ahl_item_associations_b

1215: /*
1216: CURSOR get_associated_items(c_item_group_id NUMBER) IS
1217: SELECT inventory_item_id,
1218: inventory_org_id
1219: FROM ahl_item_associations_b
1220: WHERE item_group_id = c_item_group_id;
1221: l_get_associated_item get_associated_items%ROWTYPE;
1222: */
1223:

Line 1979: ahl_item_associations_b I

1975: SELECT M.relationship_id,
1976: I.inventory_item_id,
1977: I.inventory_org_id
1978: FROM ahl_mc_relationships M,
1979: ahl_item_associations_b I
1980: WHERE M.relationship_id = p_relationship_id
1981: AND M.item_group_id = I.item_group_id
1982: AND trunc(nvl(M.active_start_date,SYSDATE)) <= trunc(SYSDATE)
1983: AND trunc(nvl(M.active_end_date, SYSDATE+1)) > trunc(SYSDATE);

Line 1990: FROM ahl_item_associations_b

1986: /*
1987: CURSOR get_associated_items(c_item_group_id NUMBER) IS
1988: SELECT inventory_item_id,
1989: inventory_org_id
1990: FROM ahl_item_associations_b
1991: WHERE item_group_id = c_item_group_id;
1992: l_get_associated_item get_associated_items%ROWTYPE;
1993: */
1994: --Given an instance_id, get all of its immediate children from csi_ii_relationships