APPS.INV_GENEALOGY_PUB dependencies on CSI_ITEM_INSTANCES

Line 692: from csi_item_instances

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

Line 698: from csi_item_instances

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

Line 720: from csi_item_instances

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

Line 726: from csi_item_instances

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

Line 748: from csi_item_instances

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

Line 754: from csi_item_instances

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

Line 773: from csi_item_instances

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

Line 779: from csi_item_instances

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

Line 819: from csi_item_instances

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

Line 825: from csi_item_instances

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