DBA Data[Home] [Help]

APPS.AHL_VWP_TASKS_PVT dependencies on CSI_ITEM_INSTANCES

Line 522: CSI_ITEM_INSTANCES CSIS,

518: AHL_VISIT_TASKS_VL ORIGTSK,
519: AHL_MR_ROUTES AMRR,
520: AHL_MR_HEADERS_VL AMRH,
521: AHL_UNIT_EFFECTIVITIES_B AUEF,
522: CSI_ITEM_INSTANCES CSIS,
523: CS_INCIDENTS_ALL_B SR,
524: BOM_DEPARTMENTS BDPT,
525: FND_LOOKUP_VALUES LKUP1,
526: FND_LOOKUP_VALUES LKUP2,

Line 620: CSI_ITEM_INSTANCES CSIS,

616: AHL_VISIT_TASKS_TL ATSKL,
617: AHL_VISIT_TASKS_VL ORIGTSK,
618: AHL_MR_HEADERS_VL AMRH,
619: AHL_UNIT_EFFECTIVITIES_B AUEF,
620: CSI_ITEM_INSTANCES CSIS,
621: CS_INCIDENTS_ALL_B SR,
622: AHL_VWP_STAGES_VL ASTG,
623: BOM_DEPARTMENTS BDPT,
624: FND_LOOKUP_VALUES LKUP1,

Line 707: CSI_ITEM_INSTANCES CSIS,

703: to_char(NULL) MR_DESCRIPTION
704: FROM AHL_VISITS_VL AVTS,
705: AHL_VISIT_TASKS_VL ATSK,
706: AHL_VISIT_TASKS_VL ORIGTSK,
707: CSI_ITEM_INSTANCES CSIS,
708: CS_INCIDENTS_ALL_B SR,
709: AHL_VWP_STAGES_VL ASTG,
710: BOM_DEPARTMENTS BDPT,
711: FND_LOOKUP_VALUES_VL LKUP1,

Line 1415: FROM CSI_ITEM_INSTANCES

1411: -- To find Item ID and Item OrgID for Instance Id
1412: -- while creating unassociated task for a non-routine job
1413: CURSOR c_Serial (p_serial_id IN NUMBER) IS
1414: SELECT Inventory_Item_Id, Inv_Master_Organization_Id
1415: FROM CSI_ITEM_INSTANCES
1416: WHERE Instance_Id = p_serial_id;
1417:
1418: -- Begin changes by rnahata for Issue 105
1419: --Cursor to fetch instance id when instance number is passed

Line 1423: SELECT instance_id FROM csi_item_instances csii

1419: --Cursor to fetch instance id when instance number is passed
1420: -- jaramana on Feb 14, 2008
1421: -- Changed data type to VARCHAR2
1422: CURSOR c_get_instance_id(p_instance_number IN VARCHAR2) IS
1423: SELECT instance_id FROM csi_item_instances csii
1424: WHERE instance_number = p_instance_number;
1425:
1426: --Cursor to fetch instance quantity
1427: CURSOR c_get_instance_qty(p_instance_id IN NUMBER) IS

Line 1428: SELECT quantity FROM csi_item_instances csii

1424: WHERE instance_number = p_instance_number;
1425:
1426: --Cursor to fetch instance quantity
1427: CURSOR c_get_instance_qty(p_instance_id IN NUMBER) IS
1428: SELECT quantity FROM csi_item_instances csii
1429: WHERE instance_id = p_instance_id;
1430:
1431: l_instance_qty NUMBER := 0;
1432: -- End changes by rnahata for Issue 105

Line 7328: FROM mtl_system_items_b mtl, csi_item_instances csi

7324: -- Added by rnahata for Issue 105
7325: -- To fetch if the instance is serial controlled/non-serial controlled.
7326: CURSOR c_check_inst_nonserial(c_instance_id IN NUMBER) IS
7327: SELECT 'X'
7328: FROM mtl_system_items_b mtl, csi_item_instances csi
7329: WHERE csi.instance_id = c_instance_id
7330: AND csi.inventory_item_id = mtl.inventory_item_id
7331: AND NVL(csi.inv_organization_id, csi.inv_master_organization_id) = mtl.organization_id
7332: AND mtl.serial_number_control_code = 1;

Line 7517: SELECT quantity FROM csi_item_instances csii

7513:
7514: -- Begin changes by rnahata for Issue 105
7515: --To fetch instance quantity
7516: CURSOR c_get_instance_qty(p_instance_id IN NUMBER) IS
7517: SELECT quantity FROM csi_item_instances csii
7518: WHERE instance_id = p_instance_id;
7519:
7520: --To fetch instance id for 'Planned' MRs
7521: CURSOR c_get_instance_id (p_unit_effectivity IN NUMBER) IS

Line 7845: SELECT quantity FROM csi_item_instances csii

7841:
7842: -- Begin changes by rnahata for Issue 105
7843: --Cursor to fetch instance quantity
7844: CURSOR c_get_instance_qty(p_instance_id IN NUMBER) IS
7845: SELECT quantity FROM csi_item_instances csii
7846: WHERE instance_id = p_instance_id;
7847:
7848: l_instance_qty NUMBER := 0;
7849: -- End changes by rnahata for Issue 105