APPS.AHL_VWP_TASKS_PVT dependencies on CSI_ITEM_INSTANCES

Line 579: CSI_ITEM_INSTANCES CSIS,

575: AHL_VISIT_TASKS_VL ORIGTSK,
576: AHL_MR_ROUTES AMRR,
577: AHL_MR_HEADERS_VL AMRH,
578: AHL_UNIT_EFFECTIVITIES_B AUEF,
579: CSI_ITEM_INSTANCES CSIS,
580: CS_INCIDENTS_ALL_B SR,
581: BOM_DEPARTMENTS BDPT,
582: FND_LOOKUP_VALUES LKUP1,
583: FND_LOOKUP_VALUES LKUP2,

Line 706: CSI_ITEM_INSTANCES CSIS,

702: AHL_VISIT_TASKS_TL ATSKL,
703: AHL_VISIT_TASKS_VL ORIGTSK,
704: AHL_MR_HEADERS_VL AMRH,
705: AHL_UNIT_EFFECTIVITIES_B AUEF,
706: CSI_ITEM_INSTANCES CSIS,
707: CS_INCIDENTS_ALL_B SR,
708: AHL_VWP_STAGES_VL ASTG,
709: BOM_DEPARTMENTS BDPT,
710: FND_LOOKUP_VALUES LKUP1,

Line 822: CSI_ITEM_INSTANCES CSIS,

818: --manisaga added all the attributes and ROUTE_ID as part of DFF Enablement 0n 18-Feb-2010--End
819: FROM AHL_VISITS_VL AVTS,
820: AHL_VISIT_TASKS_VL ATSK,
821: AHL_VISIT_TASKS_VL ORIGTSK,
822: CSI_ITEM_INSTANCES CSIS,
823: CS_INCIDENTS_ALL_B SR,
824: AHL_VWP_STAGES_VL ASTG,
825: BOM_DEPARTMENTS BDPT,
826: FND_LOOKUP_VALUES_VL LKUP1,

Line 1874: FROM CSI_ITEM_INSTANCES

1870: -- To find Item ID and Item OrgID for Instance Id
1871: -- while creating unassociated task for a non-routine job
1872: CURSOR c_Serial (p_serial_id IN NUMBER) IS
1873: SELECT Inventory_Item_Id, Inv_Master_Organization_Id
1874: FROM CSI_ITEM_INSTANCES
1875: WHERE Instance_Id = p_serial_id;
1876:
1877: -- Begin changes by rnahata for Issue 105
1878: --Cursor to fetch instance id when instance number is passed

Line 1882: SELECT instance_id FROM csi_item_instances csii

1878: --Cursor to fetch instance id when instance number is passed
1879: -- jaramana on Feb 14, 2008
1880: -- Changed data type to VARCHAR2
1881: CURSOR c_get_instance_id(p_instance_number IN VARCHAR2) IS
1882: SELECT instance_id FROM csi_item_instances csii
1883: WHERE instance_number = p_instance_number;
1884:
1885: --Cursor to fetch instance quantity
1886: CURSOR c_get_instance_qty(p_instance_id IN NUMBER) IS

Line 1887: SELECT quantity FROM csi_item_instances csii

1883: WHERE instance_number = p_instance_number;
1884:
1885: --Cursor to fetch instance quantity
1886: CURSOR c_get_instance_qty(p_instance_id IN NUMBER) IS
1887: SELECT quantity FROM csi_item_instances csii
1888: WHERE instance_id = p_instance_id;
1889:
1890: l_instance_qty NUMBER := 0;
1891: -- End changes by rnahata for Issue 105

Line 8631: FROM mtl_system_items_b mtl, csi_item_instances csi

8627: -- Added by rnahata for Issue 105
8628: -- To fetch if the instance is serial controlled/non-serial controlled.
8629: CURSOR c_check_inst_nonserial(c_instance_id IN NUMBER) IS
8630: SELECT 'X'
8631: FROM mtl_system_items_b mtl, csi_item_instances csi
8632: WHERE csi.instance_id = c_instance_id
8633: AND csi.inventory_item_id = mtl.inventory_item_id
8634: AND NVL(csi.inv_organization_id, csi.inv_master_organization_id) = mtl.organization_id
8635: AND mtl.serial_number_control_code = 1;

Line 8825: SELECT quantity FROM csi_item_instances csii

8821:
8822: -- Begin changes by rnahata for Issue 105
8823: --To fetch instance quantity
8824: CURSOR c_get_instance_qty(p_instance_id IN NUMBER) IS
8825: SELECT quantity FROM csi_item_instances csii
8826: WHERE instance_id = p_instance_id;
8827:
8828: --To fetch instance id for 'Planned' MRs
8829: CURSOR c_get_instance_id (p_unit_effectivity IN NUMBER) IS

Line 9672: SELECT quantity FROM csi_item_instances csii

9668:
9669: -- Begin changes by rnahata for Issue 105
9670: --Cursor to fetch instance quantity
9671: CURSOR c_get_instance_qty(p_instance_id IN NUMBER) IS
9672: SELECT quantity FROM csi_item_instances csii
9673: WHERE instance_id = p_instance_id;
9674:
9675: l_instance_qty NUMBER := 0;
9676: -- End changes by rnahata for Issue 105