APPS.AHL_UC_INSTANCE_PVT dependencies on AHL_ITEM_ASSOCIATIONS_B

Line 2282: l_interchange_type_code ahl_item_associations_b.interchange_type_code%TYPE;

2278: l_new_csi_instance_ovn NUMBER;
2279: l_parent_uc_header_id NUMBER;
2280: l_parent_instance_id NUMBER;
2281: l_position_ref_meaning fnd_lookups.meaning%TYPE;
2282: l_interchange_type_code ahl_item_associations_b.interchange_type_code%TYPE;
2283:
2284: --Variables needed for CSI API call
2285: l_csi_instance_rec csi_datastructures_pub.instance_rec;
2286: l_csi_party_rec csi_datastructures_pub.party_rec;

Line 2403: ahl_item_associations_b i,

2399:
2400: CURSOR get_interchange_type (c_instance_id NUMBER, c_relationship_id NUMBER) IS
2401: SELECT i.interchange_type_code
2402: FROM csi_item_instances c,
2403: ahl_item_associations_b i,
2404: ahl_mc_relationships m
2405: WHERE m.relationship_id = c_relationship_id
2406: AND c.instance_id = c_instance_id
2407: AND m.item_group_id = i.item_group_id

Line 3343: l_interchange_type_code ahl_item_associations_b.interchange_type_code%TYPE;

3339: l_instance_ou NUMBER;
3340: l_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3341: l_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3342: l_position_ref_meaning fnd_lookups.meaning%TYPE;
3343: l_interchange_type_code ahl_item_associations_b.interchange_type_code%TYPE;
3344:
3345: --Variables needed for CSI API call
3346: l_csi_party_rec csi_datastructures_pub.party_rec;
3347: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;

Line 3594: ahl_item_associations_b i,

3590:
3591: CURSOR get_interchange_type (c_instance_id NUMBER, c_relationship_id NUMBER) IS
3592: SELECT i.interchange_type_code
3593: FROM csi_item_instances c,
3594: ahl_item_associations_b i,
3595: ahl_mc_relationships m
3596: WHERE m.relationship_id = c_relationship_id
3597: AND c.instance_id = c_instance_id
3598: AND m.item_group_id = i.item_group_id

Line 4650: ahl_item_associations_b A

4646: to_number(NULL) uc_header_id
4647: FROM csi_item_instances C,
4648: mtl_system_items_kfv M,
4649: ahl_mc_relationships R,
4650: ahl_item_associations_b A
4651: WHERE C.inventory_item_id = M.inventory_item_id
4652: AND C.inv_master_organization_id = M.organization_id
4653: AND R.item_group_id = A.item_group_id
4654: AND C.inventory_item_id = A.inventory_item_id

Line 4976: FROM ahl_item_associations_b

4972: l_instance_details_rec ahl_instance_details%ROWTYPE;
4973:
4974: CURSOR get_priority (c_item_association_id IN NUMBER) IS
4975: SELECT priority
4976: FROM ahl_item_associations_b
4977: WHERE item_association_id = c_item_association_id;
4978:
4979: CURSOR get_csi_ii_relationship_ovn (c_instance_id NUMBER) IS
4980: SELECT object_version_number

Line 5394: ahl_item_associations_b A

5390: to_number(NULL) uc_header_id
5391: FROM csi_item_instances C,
5392: mtl_system_items_kfv M,
5393: ahl_mc_relationships R,
5394: ahl_item_associations_b A
5395: WHERE C.inventory_item_id = M.inventory_item_id
5396: AND C.inv_master_organization_id = M.organization_id
5397: AND R.item_group_id = A.item_group_id
5398: AND C.inventory_item_id = A.inventory_item_id

Line 5612: FROM ahl_item_associations_b

5608: WHERE config_status_code = 'COMPLETE');
5609:
5610: CURSOR get_priority (c_item_association_id IN NUMBER) IS
5611: SELECT priority
5612: FROM ahl_item_associations_b
5613: WHERE item_association_id = c_item_association_id;
5614:
5615: -- SATHAPLI Bug# 4912576 fix::SQLid 14402138
5616: -- The cursor definition below is changed so that reference