DBA Data[Home] [Help]

APPS.CS_COUNTERS_PUB dependencies on CSI_CTR_ITEM_ASSOCIATIONS

Line 260: FROM csi_ctr_item_associations

256: l_ctr_grp_id NUMBER;
257:
258: Cursor Grp_Tmpl(p_inv_item_id NUMBER) IS
259: SELECT group_id
260: FROM csi_ctr_item_associations
261: WHERE associated_to_group='Y'
262: AND inventory_item_id = p_inv_item_id;
263:
264: BEGIN

Line 957: FROM csi_ctr_item_associations

953: l_validation_level NUMBER;
954:
955: cursor ctr_associations IS
956: SELECT ctr_association_id, inventory_item_id
957: FROM csi_ctr_item_associations
958: WHERE counter_id = p_counter_id;
959: l_ctr_association_id number;
960: l_inventory_item_id number;
961:

Line 964: FROM csi_ctr_item_associations

960: l_inventory_item_id number;
961:
962: cursor src_ctr_associations(p_inv_item_id number) IS
963: SELECT ctr_association_id
964: FROM csi_ctr_item_associations
965: WHERE counter_id = p_mapped_counter_id
966: AND inventory_item_id = p_inv_item_id;
967: l_src_ctr_association_id number;
968: