DBA Data[Home] [Help]

APPS.AHL_COMPLEX_MX_RWSC_PVT dependencies on MTL_ITEM_LOCATIONS

Line 1545: FROM CSI_ITEM_INSTANCES CII , MTL_ITEM_LOCATIONS_KFV MIL, AHL_WORKORDERS WO

1541: SELECT CII.instance_id, CII.location_type_code,
1542: CII.instance_usage_code, CII.wip_job_id, CII.inv_locator_id,
1543: MIL.segment19, MIL.segment20, MIL.concatenated_segments inv_locator_name,
1544: MIL.subinventory_code, WO.workorder_name
1545: FROM CSI_ITEM_INSTANCES CII , MTL_ITEM_LOCATIONS_KFV MIL, AHL_WORKORDERS WO
1546: WHERE CII.instance_id = c_instance_id
1547: AND CII.inv_locator_id = MIL.inventory_location_id (+)
1548: AND CII.wip_job_id = WO.wip_entity_id(+);*/
1549:

Line 1555: FROM CSI_ITEM_INSTANCES CII , MTL_ITEM_LOCATIONS MIL, MTL_ITEM_LOCATIONS_KFV MIL_kfv, AHL_WORKORDERS WO

1551: SELECT CII.instance_id, CII.location_type_code,
1552: CII.instance_usage_code, CII.wip_job_id, CII.inv_locator_id,
1553: MIL.segment19, MIL.segment20, MIL_kfv.concatenated_segments inv_locator_name,
1554: MIL.subinventory_code, WO.workorder_name
1555: FROM CSI_ITEM_INSTANCES CII , MTL_ITEM_LOCATIONS MIL, MTL_ITEM_LOCATIONS_KFV MIL_kfv, AHL_WORKORDERS WO
1556: WHERE CII.instance_id = c_instance_id
1557: AND CII.inv_locator_id = MIL.inventory_location_id (+)
1558: AND MIL_kfv.INVENTORY_LOCATION_ID(+) = MIL.INVENTORY_LOCATION_ID
1559: AND MIL_kfv.ORGANIZATION_ID(+) = MIL.ORGANIZATION_ID

Line 1619: --l_sub_inventory mtl_item_locations_kfv.subinventory_code%TYPE;

1615: l_inst_location VARCHAR2(200) := NULL;
1616: l_visit_attr Get_Visit_Attributes%ROWTYPE;
1617: l_visit_number NUMBER := NULL;
1618: -- fix for bug 16304850
1619: --l_sub_inventory mtl_item_locations_kfv.subinventory_code%TYPE;
1620: --l_locator_name mtl_item_locations_kfv.concatenated_segments%TYPE;
1621: l_sub_inventory mtl_item_locations.subinventory_code%TYPE;
1622: l_locator_name VARCHAR2(204);
1623: -- end fix for bug 16304850

Line 1620: --l_locator_name mtl_item_locations_kfv.concatenated_segments%TYPE;

1616: l_visit_attr Get_Visit_Attributes%ROWTYPE;
1617: l_visit_number NUMBER := NULL;
1618: -- fix for bug 16304850
1619: --l_sub_inventory mtl_item_locations_kfv.subinventory_code%TYPE;
1620: --l_locator_name mtl_item_locations_kfv.concatenated_segments%TYPE;
1621: l_sub_inventory mtl_item_locations.subinventory_code%TYPE;
1622: l_locator_name VARCHAR2(204);
1623: -- end fix for bug 16304850
1624: l_job_name ahl_workorders.workorder_name%TYPE;

Line 1621: l_sub_inventory mtl_item_locations.subinventory_code%TYPE;

1617: l_visit_number NUMBER := NULL;
1618: -- fix for bug 16304850
1619: --l_sub_inventory mtl_item_locations_kfv.subinventory_code%TYPE;
1620: --l_locator_name mtl_item_locations_kfv.concatenated_segments%TYPE;
1621: l_sub_inventory mtl_item_locations.subinventory_code%TYPE;
1622: l_locator_name VARCHAR2(204);
1623: -- end fix for bug 16304850
1624: l_job_name ahl_workorders.workorder_name%TYPE;
1625: l_osp_order ahl_osp_orders_b.osp_order_number%TYPE;