APPS.INV_GENEALOGY_PUB dependencies on CSI_ITEM_INSTANCES

Line 694: from csi_item_instances

690:
691:
692: begin
693: select instance_number into l_instance_number
694: from csi_item_instances
695: where serial_number = l_serial_number
696: and inventory_item_id = l_inventory_item_id
697: and last_vld_organization_id = l_org_id;
698:

Line 700: from csi_item_instances

696: and inventory_item_id = l_inventory_item_id
697: and last_vld_organization_id = l_org_id;
698:
699: select instance_number into l_parent_instance_number
700: from csi_item_instances
701: where serial_number = i.parent_serial_number
702: and inventory_item_id = i.parent_inventory_item_id
703: and last_vld_organization_id = l_parent_org_id;
704:

Line 722: from csi_item_instances

718: IF (p_start_date_active <= i.end_date_active) THEN
719:
720: begin
721: select instance_number into l_instance_number
722: from csi_item_instances
723: where serial_number = l_serial_number
724: and inventory_item_id = l_inventory_item_id
725: and last_vld_organization_id = l_org_id;
726:

Line 728: from csi_item_instances

724: and inventory_item_id = l_inventory_item_id
725: and last_vld_organization_id = l_org_id;
726:
727: select instance_number into l_parent_instance_number
728: from csi_item_instances
729: where serial_number = i.parent_serial_number
730: and inventory_item_id = i.parent_inventory_item_id
731: and last_vld_organization_id = l_parent_org_id;
732:

Line 750: from csi_item_instances

746: IF p_end_date_active IS NULL THEN
747:
748: begin
749: select instance_number into l_instance_number
750: from csi_item_instances
751: where serial_number = l_serial_number
752: and inventory_item_id = l_inventory_item_id
753: and last_vld_organization_id = l_org_id;
754:

Line 756: from csi_item_instances

752: and inventory_item_id = l_inventory_item_id
753: and last_vld_organization_id = l_org_id;
754:
755: select instance_number into l_parent_instance_number
756: from csi_item_instances
757: where serial_number = i.parent_serial_number
758: and inventory_item_id = i.parent_inventory_item_id
759: and last_vld_organization_id = l_parent_org_id;
760:

Line 775: from csi_item_instances

771: OR (p_end_date_active >= i.start_date_active) THEN
772:
773: begin
774: select instance_number into l_instance_number
775: from csi_item_instances
776: where serial_number = l_serial_number
777: and inventory_item_id = l_inventory_item_id
778: and last_vld_organization_id = l_org_id;
779:

Line 781: from csi_item_instances

777: and inventory_item_id = l_inventory_item_id
778: and last_vld_organization_id = l_org_id;
779:
780: select instance_number into l_parent_instance_number
781: from csi_item_instances
782: where serial_number = i.parent_serial_number
783: and inventory_item_id = i.parent_inventory_item_id
784: and last_vld_organization_id = l_parent_org_id;
785:

Line 821: from csi_item_instances

817: WHERE gen_object_id = l_parent_object_id;
818:
819: begin
820: select instance_number into l_instance_number
821: from csi_item_instances
822: where serial_number = l_serial_number
823: and inventory_item_id = l_inventory_item_id
824: and last_vld_organization_id = l_org_id;
825:

Line 827: from csi_item_instances

823: and inventory_item_id = l_inventory_item_id
824: and last_vld_organization_id = l_org_id;
825:
826: select instance_number into l_parent_instance_number
827: from csi_item_instances
828: where serial_number = l_parent_serial_number
829: and inventory_item_id = l_parent_inventory_item_id
830: and last_vld_organization_id = l_parent_org_id;
831: