APPS.AHL_MC_RULE_ENGINE_PVT dependencies on CSI_ITEM_INSTANCES

Line 830: FROM CSI_ITEM_INSTANCES

826: WHERE rule_statement_id = p_rulestmt_id;
827: --
828: CURSOR get_inventory_item_csr (p_csi_ii_id IN NUMBER) IS
829: SELECT inventory_item_id
830: FROM CSI_ITEM_INSTANCES
831: WHERE instance_id = p_csi_ii_id;
832: --
833: CURSOR get_mc_ids_csr (p_csi_ii_id IN NUMBER) IS
834: SELECT hd.mc_id, hd.version_number

Line 842: FROM CSI_ITEM_INSTANCES csi1, CSI_ITEM_INSTANCES csi2

838: --
839: CURSOR check_same_inventory_item_csr (p_csi_ii_id1 IN NUMBER,
840: p_csi_ii_id2 IN NUMBER) IS
841: SELECT csi1.inventory_item_id
842: FROM CSI_ITEM_INSTANCES csi1, CSI_ITEM_INSTANCES csi2
843: WHERE csi1.instance_id = p_csi_ii_id1
844: AND csi2.instance_id = p_csi_ii_id2
845: AND csi1.inventory_item_id = csi2.inventory_item_id;
846: --

Line 862: csi_item_instances csi

858: -- Cursor to get the distinct UOM count of all the non-extra children of an instance.
859: CURSOR check_child_inst_uoms_csr(p_csi_instance_id IN NUMBER) IS
860: SELECT count(distinct unit_of_measure)
861: FROM csi_ii_relationships csi_ii,
862: csi_item_instances csi
863: WHERE csi_ii.object_id = p_csi_instance_id
864: AND csi_ii.subject_id = csi.instance_id
865: AND csi_ii.position_reference is not null
866: AND CSI_II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'

Line 874: csi_item_instances csi

870: -- Cursor to get the sum of quantities of all the non-extra children of an instance.
871: CURSOR get_tot_child_quant_csr(p_csi_instance_id IN NUMBER) IS
872: SELECT nvl(sum(quantity),0) quantity
873: FROM csi_ii_relationships csi_ii,
874: csi_item_instances csi
875: WHERE csi_ii.object_id = p_csi_instance_id
876: AND csi_ii.subject_id = csi.instance_id
877: AND csi_ii.position_reference is not null
878: AND CSI_II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'

Line 884: SELECT instance_number from csi_item_instances

880: AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate);
881:
882: -- Cursor to get the instance number for a given instance id.
883: CURSOR get_instance_number_csr(p_csi_instance_id IN NUMBER) IS
884: SELECT instance_number from csi_item_instances
885: WHERE instance_id = p_csi_instance_id;
886:
887: --
888: l_rstmt_rec get_rule_stmt_csr%ROWTYPE;

Line 905: l_instance_number CSI_ITEM_INSTANCES.INSTANCE_NUMBER%TYPE;

901:
902: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 04-Dec-2007
903: l_tot_child_quant NUMBER;
904: l_uom_count NUMBER;
905: l_instance_number CSI_ITEM_INSTANCES.INSTANCE_NUMBER%TYPE;
906: --
907: BEGIN
908:
909: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN